Forum Discussion
DAX Measure
Hi, I'm having some trouble coming up with a measure. I have a report that I refresh with new data at the beginning of each month. This new data contains changes to the old daata and new informat...
I've been instead using this formula to calculate the prior months total units?
Previous Month Total = CALCULATE(
[Count of Units]
,FILTER(
ALL('DimDate'[Month_Nbr])
, DimDate[Month_Nbr] <= MAX(DimDate[Month_Nbr] ) - 1))