Convert Tableau LOD expression to PowerBI DAX

Hi Jwheels11

My Tableau is a little rusty, but FIXED is roughly translateable to the ALLEXCEPT() function in DAX.

And in replacement of DATETIME(TODAY()) you could use NOW(). 

You would likely need to built something like:

M_ChangeDate=

Calculate(MAX('Table'[Change Date]), ALLEXCEPT('Table', 'Table'[Id]))

And to add the NOW() filter, perhaps something like:

M_ChangeDate=

Calculate(MAX('Table'[Change Date]), ALLEXCEPT('Table', 'Table'[Id]), 'Table'[Change Date] <= NOW())

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data