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 there,
So far so good. However, the relationship does not seem to work. I don't know why.
There are two measures:
The problem is that only #1 works. #2 always shows the absolutely last entry in the date table. Even trying LASTDATE(ALLSELECTED(...)) didn't work.
I have attached a screenshot to this setup below. Does anyone spot the problem? This is driving me crazy, far more complex calculations work, but this doesn't... 😕
Kind regards, chefe
P.S.:
does it it matter where (on what table that is) the measure is stored?
Hi @chefe,
Could you please post expected result here? Do you want to calculate max date of fact table using LASTDATE function? If so, please create measure using DAX below.
LastDate = LASTDATE(IR positions MTM[period_settlement_date])
Thanks,
Lydia Zhang
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |