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.
Hi,
I can not do it 😑
What I have - a fact table and a dimCalendar.
What I want - calculate the average amount over year and display it over months.
Such as...
AvgPerMonth: = if (YEAR (Calendar.Date) = YEAR (today()); SUM(Amount) / DISTINCTCOUNT (YYYYMM); SUM (Amount) / 12))
Please help me. 🙄
This is the sample data:
Date | Amount | |
01.01.2018 | 23 | |
02.01.2018 | 34 | |
01.02.2018 | 56 | |
02.02.2018 | 56 | |
01.03.2018 | 34 | |
02.03.2018 | 56 | |
01.04.2018 | 23 | |
01.05.2018 | 34 | |
01.06.2018 | 56 | |
01.07.2018 | 56 | |
02.07.2018 | 34 | |
02.08.2018 | 56 | |
04.09.2018 | 23 | |
05.09.2018 | 34 | |
05.10.2018 | 56 | |
07.10.2018 | 56 | |
08.11.2018 | 34 | |
03.12.2018 | 56 | |
01.01.2019 | 34 | |
02.01.2019 | 87 | |
01.02.2019 | 56 | |
02.02.2019 | 768 | |
01.03.2019 | 67 | |
02.03.2019 | 34 | |
01.04.2019 | 98 | |
01.05.2019 | 76 | |
01.06.2019 | 55 | |
01.07.2019 | 44 | |
02.07.2019 | 98 | |
02.08.2019 | 76 | |
04.09.2019 | 55 | |
05.09.2019 | 44 | |
05.10.2019 | 98 | |
07.10.2019 | 76 | |
08.11.2019 | 55 | |
03.12.2019 | 44 | |
01.01.2020 | 56 | |
05.02.2020 | 23 | |
06.02.2020 | 76 | |
03.03.2020 | 55 | |
03.03.2020 | 44 |
I would like to have that:
Solved! Go to Solution.
Hi @denxx34 ,
You can try this approach.
1. Create Calculated Columns
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi @denxx34 ,
You can try this approach.
1. Create Calculated Columns
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
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 |
---|---|
47 | |
26 | |
19 | |
15 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |