PowerPivot Forum

I’m on an iPad, so I can’t see your sample datamodel (just the pivot). At least conceptually, here is the problem with totalling distinctcount. Imagine you have sales by month by customer A,B,C Jan A=2 B=1 A=1 Feb A=4 C=3 How many distinct customers have purchased? Jan =2, Feb =2, right? But what do...

This is a good approach if it helps. Another approach is to use Values(calendar[day of year]) to “harvest” which days of the year are in the current filter context. You can then to a time shift by removing all filters from the calendar, put a new filter on last year (by detecting the current year an...

Check the data types of your columns to make sure they are not different in PP vs PBI.

Bonus tips
- read the error message that it gives when it doesn’t work
- consider if this should be a column or a measure https://exceleratorbi.com.au/calculated ... sures-dax/

I haven’t read you question in detail, but let me make an observation. I have a saying: If you come from a database background, every DAX problem looks like a DAX query. But the truth is, Power BI and DAX are not the same as a traditional database. In power BI, you should be modelling your data with...

I suggest using this approach. https://www.daxpatterns.com/new-and-ret ... customers/

I suggest you split the responses into rows. You can do this in power query using the split columns by delimiter feature. Just make sure you select “to rows”. Then you table will have one row for each answer.

This is not enough information to be able to help you

I assume you have a column for scenario. I would create 2 disconnected tables of the scenario names. Write 2 measures that respond to these selections (one to each). Something like this VAR selectedScenario = selectedvalue(disconnectedTable1[scenario]) Return CALCULATE(Base measure],datatable[scenar...

Mmmmm, I’m having second thoughts now. Does each project have the 3 date columns in your data against a single row in the table (ie the row for each project)?

To me, this is the same problem as I wrote about here https://exceleratorbi.com.au/calculatin ... ax-part-2/. My article is about time, but it’s the same with dates. I would use this technique to calculate the total, then you can subtract the others to get the missing number