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
does it it matter where (on what table that is) the measure is stored?
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
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021