YTD calculations without date table

[Anonymous]

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

[Stachu · Accepted 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 )
    )

[Anonymous]

Hi Stachu,

Thanks for your reply. In calculate function you have used [Measure]. What it is refering to?

[Stachu]

you should replace it with whatever measure you want to calculate, e.g. 

SUM(Table[Column])