Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |