DAX help

[filippoalicicco]

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

[v-jiascu-msft]

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]

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.

[v-jiascu-msft · Accepted solution]

Hi @filippoalicicco,

I have a demo in hand. Please refer to the attachment and snapshot below.

Best Regards,
Dale

[filippoalicicco]

Now it works!!

thank you so much

filippo