Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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])
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |