Measure Formula

[notaexpert]

My measure formula looks like this: Aktueller Wert = IF(SUM(List1[Wert])=0,0,SUM(List1[Wert]))

My values ​​are usually from Monday to Friday and always 1 day old. So on Tuesday I see Monday. However, I would like Friday to be displayed on Saturday or Sunday, for example. How do I do that?

thanks guys.

[v-rongtiep-msft · Accepted solution]

Hi @ryan_mayu , 

Thanks for your quick response.

Hi @notaexpert ,

Please refer to my pbix file to see if it helps you.

Create a measure.

Measure =
VAR _1 =
    CALCULATE (
        MAX ( 'table1'[date] ),
        FILTER (
            ALL ( table1 ),
            table1[weekday] = 5
                && table1[date] < SELECTEDVALUE ( table1[date] )
        )
    )
VAR _2 =
    CALCULATE (
        MAX ( table1[date] ),
        FILTER ( ALL ( table1 ), table1[date] < SELECTEDVALUE ( table1[date] ) )
    )
VAR _3 =
    CALCULATE (
        MAX ( table1[value] ),
        FILTER ( ALL ( table1 ), table1[date] = _2 )
    )
RETURN
    IF (
        MAX ( table1[weekday] ) <= 5,
        _3,
        IF (
            MAX ( table1[weekday] ) >= 6,
            CALCULATE (
                MAX ( table1[value] ),
                FILTER ( ALL ( table1 ), table1[date] = _1 )
            )
        )
    )

How to Get Your Question Answered Quickly - Microsoft Fabric Community

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.

[ryan_mayu]

could you pls provide some sample data and expected output?