Forum Discussion

vejas's avatar
vejas
Icon for Helper I rankHelper I
8 years ago

Compare Sales

  Hello ,      I want to compare sales from different periods. This is my table     My Calendar Table -  2016-01-01 till 2018-12-31 Measures: Sales Total = SUM(Sales[Amount]) Sales Pre...
Need Help
vejas's avatar
vejas
Icon for Helper I rankHelper I
8 years ago

For Sales Change my solution is

 

Sales Change = IF(OR(ISBLANK([Sales Total]);ISBLANK([Sales Previous Year]));BLANK();[Sales Total]-[Sales Previous Year])

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
8 years ago

What I’m saying is that if you use the measure I posted for each of your measures, the table will only display the values you,ve circled in green.

 

EDIT: Actually, that might filter out the previous years values for 2017. Try the following with the measures:

 

<<New Measures>>  = IF(OR(calendar[year]= YEAR(TODAY()) - 1 , calendar[year] = YEAR(TODAY())  && calendar[month] < MONTH(TODAY())),  [<<YOUR OLD MEASURE>>], BLANK())