Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, i am trying to do a running total measure using another measure, Monthly Delta, but the values are not corret. I will put the information below:
Measures :
In this table i am using this measure Parallel :
Note : The values of Total Consultants Invoiced Parallel MOM / Monthly Delta are Correct.
The Incorrect values are RunnTotal Consultants Invoiced Paralell MOM / RT Delta.
Thanks for your help!
@devesqdeves , try like
Total Consultants Invoiced ParallelPeriod =
CALCULATE([Total Consultants Invoiced],
dateadd('Date'[Data],-1,MONTH))
RunnTotal Consultants Invoiced Paralell MOM =
var _max = MAX('Date'[Data])
var _date = date(year(_max) , month(_max)-1, day(_max))
return
CALCULATE([Invoiced Parallel MOM],FILTER(ALL('Date'),'Date'[Data]<=_date))
@amitchandak Hi , thanks for the input , i tried ur measures and it gave this error :
MdxScript(Model) (108, 13) Calculation error in measure "DW FCTHCFAC"[RunnTotal Consultants Invoiced Paralell MOM]: An argument of the function 'DATE' has the wrong data type or the result is too large or too small.
What should i do ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |