sum week end value at monday

[filippoalicicco]

Good Monring experts!

I need help bucause I don't manage to create the mesaure in object.

I have a table with all days of week and i need to "sum" saturday and sunday on monday. I try with the suggestion in this tread https://community.powerbi.com/t5/Desktop/Sum-weekend-values-on-monday/td-p/189506 but it doesn't work.

Can we help me? I atttach the image

thank you

fil

[filippoalicicco · Accepted solution]

Hi and thank you for your answer!!

I have a problem with this peace of DAX:

FILTER (
                ALLSELECTED ( Table ),
                YEAR ( Table[Date] ) = YEAR ( currdate )
                    && WEEKNUM ( Table[Date] ) = WEEKNUM ( currDate, 1 )

When I write the YEAR DAX I can't insert table date. Is it normal???? 

[v-shex-msft]

Hi @filippoalicicco,

You can consider to use if statement with weekday function to get current date, then use it to filter and summary record.

Summary on Monday =
VAR currDate =
    MAX ( Table[Date] )
RETURN
    IF (
        WEEKDAY ( currDate, 2 ) = 1,
        CALCULATE (
            SUM ( Table[Amount] ),
            FILTER (
                ALLSELECTED ( Table ),
                YEAR ( Table[Date] ) = YEAR ( currdate )
                    && WEEKNUM ( Table[Date] ) = WEEKNUM ( currDate, 1 )
            )
        ),
        SUM ( Table[Amount] )
    )

Regards,

Xiaoxin Sheng

[StuBee]

Hi @v-shex-msft 

Is it possible to do this as a column?

This is almost exactly what I have been hunting for, but I want to be able to look at this as a trend.

[filippoalicicco · Accepted solution]

Hi and thank you for your answer!!

I have a problem with this peace of DAX:

FILTER (
                ALLSELECTED ( Table ),
                YEAR ( Table[Date] ) = YEAR ( currdate )
                    && WEEKNUM ( Table[Date] ) = WEEKNUM ( currDate, 1 )

When I write the YEAR DAX I can't insert table date. Is it normal???? 

[v-shex-msft · Accepted solution]

Hi @filippoalicicco,

>>When I write the YEAR DAX I can't insert table date. Is it normal???? 

Can you please share more detail? BTW, my formula is a measure. Which connection mode you test, is it direct query?

Regards,

Xiaoxin Sheng