Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
I need hep to get the related value from the same table. I have a tabe below named Forecast Histroy and i need to find out the associated 'Old Value' for the 'Max Date' in the column 'Max-old-Forecast-Value'.
Max date column is derived from the edited date column to identify the latest date and time an opportunity was edited. Now that i have the max date, i need to find out what is the associated latest 'old value'
Solved! Go to Solution.
Hi @KRISH80 ,
This was tricky thing to resolve, but I have got a way to do it.
You MAX DATE date is fine.
For Maximum OLD Value, use the following DAX expression:
I tried using the DAX :
Hi @KRISH80 ,
Try modifying your DAX as follows:
Thanks a lot Pragati.. butit is not helping with opportunities which have multiple entries. Can you help me with your email id pls ? such that i can share some sample file with you ?
Hi @KRISH80 ,
This was tricky thing to resolve, but I have got a way to do it.
You MAX DATE date is fine.
For Maximum OLD Value, use the following DAX expression: