Forum Discussion
Solved
Calculate value difference from column of a same table with hierarchy from another table
Hi everyone, I have to calculate value difference between rows of the same column in one table where "File Name" column from "Database" table has "File for comparison" file from "DIM_File" table....
I would look at the LOOKUPVALUE function in DAX. https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
Greg_Deckler
Community Champion
Community ChampionI would look at the LOOKUPVALUE function in DAX. https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
Worked like a charm :)
Thanks!
