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.
Hello everyone,
Does anybody here created a report that shows the amount for over a period of time but the data itself doesn't have dates?
I have a date dimension but I don't know how to combine it with my data.
This is my sample data:
Country | Total Amount |
Country A | 100 |
For Month of October:
Country | Month | Amount |
Country A | January | 10.00 |
Country A | February | 10.00 |
Country A | March | 10.00 |
Country A | April | 10.00 |
Country A | May | 10.00 |
Country A | June | 10.00 |
Country A | July | 10.00 |
Country A | August | 10.00 |
Country A | September | 10.00 |
Country A | October | 10.00 |
Month of November:
Country | Month | Amount |
Country A | January | 9.09 |
Country A | February | 9.09 |
Country A | March | 9.09 |
Country A | April | 9.09 |
Country A | May | 9.09 |
Country A | June | 9.09 |
Country A | July | 9.09 |
Country A | August | 9.09 |
Country A | September | 9.09 |
Country A | October | 9.09 |
Country A | November | 9.09 |
Solved! Go to Solution.
Hi ogureisuo,
You could try below to see whether it work or not. Create relationship and measure like below
Measure 2 = SUM('Table 2'[AMOUNT])/CALCULATE(COUNT(t2[MONTH]),ALL(t2))
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi ogureisuo,
You could try below to see whether it work or not. Create relationship and measure like below
Measure 2 = SUM('Table 2'[AMOUNT])/CALCULATE(COUNT(t2[MONTH]),ALL(t2))
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much!!
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |