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,
This dax calculates an average based on future months.
However, the amount only shows as a total, but I need it to show in the months that are considered future months.
Can you help?
Hi,
I would expect that when Actual1 is nil,
the amount will be displaid on each row in the corresponding row in column RF2.
This shows at the moment, and I expect that the circled field would have the amount required.
This should repeat if there's another blank in column Actual1.
The same amount should repeat. The aount shows in the sum at the moment.
It's calculting the overall difference between Forecast1 and Actual1 and dividing it by the amount of months to go:
Data Set
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 |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |