Forum Discussion
Solved
Max Date from Dim table using Fact table filter applied
Been scrolling through the forums but haven't found an answer to this yet (likely searching the wrong terms), hoping someone here can point me in the right direction. I'm just coming back to the Data...
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.
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.
Wasn't the cost issue. It was the need to give your mobile phone to them to use it.