Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello Community,
I created a Measure which forecast values for Months which currently do not have any Data.
In a Matrix it shows the correct results for exisiting months(current value of a measure) and for months, where the Measure is currently blank.
But the total is wrong. It still only show the total for the existing months.
The measures are based on my facttable. The Fact table currently has data until end of August. There are no rows for Months after august. Also when i put the Measure as a Column in my Date Table, it only returns the results for months which are available in the Fact Table.
Hi @BIlix there is no definition for relate measure or some other details.
Still, if you want to control / limit figures "up to the last date of your fact table" use below logic for your measure
CALCULATE(
MAX(Your Fact bale[Related Date Column]),
REMOVEFILTERS()
)
Did I answer correctly? Kudos appreciate / accept solution.
Proud to be a Super User!
User | Count |
---|---|
15 | |
11 | |
6 | |
6 | |
5 |
User | Count |
---|---|
29 | |
17 | |
11 | |
7 | |
5 |