Forum Discussion

filippoalicicco's avatar
filippoalicicco
Frequent Visitor
7 years ago
Solved

DAX help

Good mornig, I need help for PBI Dax.    I have a table with two colums: the first with the date (from 2017/12 to 2018/09) and the second with amount of accounts opened.   I would like to know t...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Filippo,

 

1. The data is from 2017/12 to 2018/09. What could the same period be?

2. What's the granularity? Month or Day?

3. If you try the function SAMEPERIODLASTYEAR, you need a Date table that has continuous dates. 

4. Can you share a sample?

 

 

Best Regards,
Dale

filippoalicicco's avatar
filippoalicicco
Frequent Visitor
7 years ago

1) the same period that i want to analize is : from 2017/01 to 2017/09 to compare from 2018/01 to 2018/09 

2) Granularity in Month

 

 

 

I attach a photo with ma table and i write you an example:

 

Colum "aperture conti correnti" --> sum form from 2017/01 to 2017/09 is 103.448 and sum from 2018/01 to 2018/09 is 86.152 --> percentage difference is -16%.

 

I need a dax that in next month calculates from 2017/01 to 2017/10 and the same period for 2018.

 

 

 

    • filippoalicicco's avatar
      filippoalicicco
      Frequent Visitor
      7 years ago

      Now it works!!

      thank you so much

       

      filippo