Forum Discussion
Solved
Measure with Lookupvalue?
Hello, I am trying to create a formula that uses a lookupvalue function within a measure (Which might not be the best way to solve my problem). What I am trying to do is create a measure that fin...
akov,
You may take a look at the following post.
https://community.powerbi.com/t5/Desktop/Find-last-value-based-on-date/m-p/293150#M129228
akov Can you post an excel sheet with dummy data for this problem? Also why are you not creating the 2nd column as a measure.
In the mean time try using an if statement comparing max date with from date and give the report date as output if true.
IF(MaxDate = FromDate,ReportDate,NULL)