Forum Discussion
Alternative for RELATED function
In the simplest sense I have two tables as follows. Live Data is as it sounds, records with current data. History takes a snapshot of open records on the first of each month. Live Data ID ...
Hi Anonymous ,
Have you tried looking into LOOKUPVALUE dax function?
https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Thanks for that but LOOKUPVALUE hasn't been any help. I there is a cautionary note in The Definitive Guide to DAX that explains the reason why it's not my solution. The note basically says that LOOKUPVALUE ignores existing filter context.
Since I want/need the calendar dates to be in play here I can't use LOOKUPVALUE.