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,
Share some data to work with and show the expected result. Please also offer an explaination vial textboxes/comments.
You are replying after quite many days. Also, pleas read my comment posted on Decemebr 8, 2023.
I did read it. I replied to rongtiep here: https://community.fabric.microsoft.com/t5/Desktop/Show-latest-value-on-each-day/m-p/3574123/highligh... but he didn't respond anymore. The reason I only reply now to your comment is because I thought rongtiep was able to help me.
I really cannot understand the expected result. May be someone else will help you.
Hi @PowerBI_RD ,
Please have a try.
Latest Stage Value =
VAR LastDayAvailable =
CALCULATE (
MAX ( 'Date_table OppFieldHistory'[Date] )
)
VAR CurrentDates =
FILTER (
VALUES ( 'Date_table OppFieldHistory'[Date] ),
'Date_table OppFieldHistory'[Date] <= LastDayAvailable
)
VAR LatestStage =
CALCULATE (
MAX ( 'Date_table OppFieldHistory'[Stage] ),
DATESYTD ( CurrentDates )
)
VAR Result =
CALCULATE (
[Total Opportunities Weighted Amount OppFieldHistory],
'Date_table OppFieldHistory'[Stage] = LatestStage,
DATESYTD ( CurrentDates )
)
RETURN
Result
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
109 | |
106 | |
87 | |
76 | |
66 |
User | Count |
---|---|
126 | |
112 | |
99 | |
82 | |
73 |