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 have 2 measures:
- one to determine the last output-date of a product, this one works just fine, and does indeed return the correct date
Solved! Go to Solution.
Thanx to everyone for trying to help.
unfortunately your solutions did not work for me.
But I managed to get the desired result, not by making a measure, but rather 2 calculated columns in my Item table
Thanx to everyone for trying to help.
unfortunately your solutions did not work for me.
But I managed to get the desired result, not by making a measure, but rather 2 calculated columns in my Item table
Hi @StefanH74 ,
Please check the formulas. ALLEXCEPT() is to do the calculation based on [product].
last outputdate =
CALCULATE (
MAX ( fctArtikelposten[Posting_Date] ),
FILTER (
ALLEXCEPT ( fctArtikelposten, [product] ),
fctArtikelposten[Entry_Type] = "Output"
)
)
1e salesdate after last outputdate =
CALCULATE (
MIN ( fctArtikelposten[Posting_Date] ),
FILTER (
ALLEXCEPT ( fctArtikelposten, [product] ),
fctArtikelposten[Entry_Type] = "Sales"
&& fctArtikelposten[Posting_Date] >= [last outputdate]
)
)
Best Regards,
Jay
problem seems to be in this date-filter. this measure also ignores the filter
ok, I found that the problem lies somewhere in the "last outputdate" - measure
because if I put in a hard value in measure 2, then it works correctly
test = CALCULATE(MIN(fctArtikelposten[Posting_Date]),FILTER(fctArtikelposten,fctArtikelposten[Posting_Date]>=43830))
This will give me the first date there was activity on an article after 31-12-2019 (=43830)
still no idea on how to fix it though, or why it wont accept the "last outputdate" instead
Hi @StefanH74
please try
2ndMeasure =
CALCULATE (
CALCULATE (
MIN ( fctArtikelposten[Posting_Date] ),
fctArtikelposten[Entry_Type] = "Sales"
),
FILTER ( fctArtikelposten, fctArtikelposten[Posting_Date] >= [last outputdate] )
)
This does indeed remove the PLACEHOLDER error, only the measure is wrong, it returns the very first sales date, not the first after the last output-date. I looks like it doesnt apply the last filter:
FILTER ( fctArtikelposten, fctArtikelposten[Posting_Date] >= [last outputdate]
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 |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |