Forum Discussion
Max Date from Dim table using Fact table filter applied
Here is the solution:
Model view:
I usually don't ask, but this time I'd appreciate an Accepted solution with a thumbs up. 😁 Cheers!
Here is the solution:
Model view:
I usually don't ask, but this time I'd appreciate an Accepted solution with a thumbs up. 😁 Cheers!
That worked a charm. I thought for a second it wasn't working as the cards were showing up blank. But I think it was because it tooks a while for the measures to populate.
Weird, should be instant. At least, it is on my PC.
Also, try showing ChatGPT 4 (use the Data Analyst GPT) the model with the relation and ask it to come up with the DAX code. Should be interesting.
Unfortunately I won't use ChatGPT since it requires PII to utilise it. I had tried some local LLMs but they didn't quite cut it with their limited parameter size.
