Forum Discussion

Ciria's avatar
Ciria
Advocate III
8 years ago

Hi v-chuncz-msft

 

It makes sense.

I will try and I will come back.

 

Thanks for the support :-)

Ciria's avatar
Ciria
Advocate III
8 years ago

Hi v-chuncz-msft, Dears all:

 

I found some free time to put this knowledge to test.

 

The solution you propose works, but it is important to highlight some points:

  • You can't use on tables (as values) the measure you've created following along this tutorial, because it doesn't work. It'll only show results where the Date/Day has sales on previous and current year.
  • The measure is able to dismiss the extra dates from periods where the latest date of the month hasn't been reached.
    • Example: Last date with sales, August 14th 2017
    • Slicer: Filtering from August 01st to August 31st 2017
    • Two KPI's defined: Using this measure and using "Total Sales LY" directly on DIVIDE function.
  • This means you can only use this calculation/measure for % Calculations or KPI's calculations purposes.

 

 

Here the file for testing or commenting:

 

https://www.dropbox.com/s/88dtadb0s7m1hpd/Dummy%20Model.pbix?dl=0

 

Awaiting for your comments :-)