Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
24 | |
19 | |
14 | |
10 | |
7 |