Show latest value on each day

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.  Please also offer an explaination vial textboxes/comments.

[PowerBI_RD]

Hi @Ashish_Mathur I have added the pbix file, can you take a look please?

[Ashish_Mathur]

You are replying after quite many days.  Also, pleas read my comment posted on Decemebr 8, 2023.

[PowerBI_RD]

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.

[Ashish_Mathur]

I really cannot understand the expected result.  May be someone else will help you. 

[Anonymous]

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.