Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
Hi @filippoalicicco,
I have a demo in hand. Please refer to the attachment and snapshot below.
Best Regards,
Dale
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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
125 | |
78 | |
76 | |
59 | |
51 |
User | Count |
---|---|
166 | |
84 | |
68 | |
67 | |
57 |