Forum Discussion
Kurt4597
Helper I
Helper IYoY on a graph
I am trying to create a year on graph from the following tables Table 1: DateDim Table 2: Sales I will have the date on the datedim filter set as follows and the g...
Your previous year measure would be something like this
PY Sales = CALCULATE(SUM(Sales[Count]),DATEADD(Dim_date[Date],-1,year))
Syk
Resident Rockstar
Resident RockstarYour previous year measure would be something like this
PY Sales = CALCULATE(SUM(Sales[Count]),DATEADD(Dim_date[Date],-1,year))