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.
Solved! Go to Solution.
Hi
I added the RETURN command, and it is working perfectly!
Many thanks
Joe
Hi
Thank you for your time!
No. Calendar cust off at current day.
Joe
Then let's say you have a filter to limit to only July. Then your calculation is run in that context, thus finding the max year associated with July: 2018.
If you want the max year from the calendar table, and ignore filters, you can do something like:
Sales YTD = var max_year = CALCULATE(MAX(Calendar2[Year]), ALL(Calendar2)) return CALCULATE([Ttl Sales], //***Edit: Had forgotten to include "return"// FILTER(trans,year(trans[DATE])=max_year), FILTER(trans,trans[Hold?]="n"))
Note: this is not a typical YTD function, as YTD usually refers to the cumulative value each month.
Hi
Thank you for your explanation of the error and formula suggestion.
I'm getting this error:
The syntax for 'CALCULATE' is incorrect. (DAX(var max_year = CALCULATE(MAX(Calendar2[Year]), ALL(Calendar2))CALCULATE([Ttl Sales],FILTER(trans,year(trans[DATE])=max_year),FILTER(trans,trans[Hold?]="n")))).
Any ideas?
Hi
I added the RETURN command, and it is working perfectly!
Many thanks
Joe
cuts*
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |