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 the sum of account in the same period of 2017 and 2018. Is it possible? I try with DAX SAMEPERIODLASTYEAR but it don't work.

 

Can You Help me?

 

thx

filippo

4 Replies

  • 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.