Forum Discussion
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...
Hi filippoalicicco,
I have a demo in hand. Please refer to the attachment and snapshot below.
Best Regards,
Dale
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.
Hi filippoalicicco,
I have a demo in hand. Please refer to the attachment and snapshot below.
Best Regards,
Dale
Now it works!!
thank you so much
filippo