Forum Discussion
kcantor
Community Champion
Community ChampionCreate a measure/calculated field
Greetings, As a new PowerBI user, I am struggling wtih what is probably a simple DAX statement. Of course I have not successfully integrated this into PowerPivot either so all helap is appreciated. ...
Hello,
Create a measure with CALCULATE(SUM([Sales Totals]), SAMEPERIODLASTYEAR([DateColumn])), and then, calculate the variance and %.
Vicenç Lahoz
Greg_DecklerCommunity Champion
Community ChampionNot sure of your exact data layout without example data.
Have a look here:
http://www.daxpatterns.com/time-patterns/