Forum Discussion
YTD calculations without date table
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 organis...
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])