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.
Hi
I don't have date column in my data set but i have period(month) like 1,2,3...12. how can i do YTD calculations without having dates.
I want to create a graph visual of YTD by sales organisation.
Thanks,
Paruchuri
Solved! Go to Solution.
YTD is all months until the one selected, so something like this would work:
Measure YTD = VAR SelectedMonth = MAX ( Table[Period] ) RETURN CALCULATE ( [Measure], FILTER ( ALL ( Table[Period] ), Table[Period] <= SelectedMonth ) )
YTD is all months until the one selected, so something like this would work:
Measure YTD = VAR SelectedMonth = MAX ( Table[Period] ) RETURN CALCULATE ( [Measure], FILTER ( ALL ( Table[Period] ), Table[Period] <= SelectedMonth ) )
Hi Stachu,
Thanks for your reply. In calculate function you have used [Measure]. What it is refering to?
you should replace it with whatever measure you want to calculate, e.g.
SUM(Table[Column])
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 |
---|---|
106 | |
104 | |
77 | |
68 | |
61 |
User | Count |
---|---|
148 | |
107 | |
107 | |
83 | |
70 |