Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |