Daily Ordering and monitoring

[Anonymous]

Good Morning,
Evaluating the values of a kpi on daily basis (mon, tue, ...) on the current week I have troubles:
A-Making the current weekday start with monday (in the data filter, when setting current week power bi automatically sets Sunday as first day)
B-Ordering the values shown in the matrix (exception made for sunday due to "A") from monday to saturday.
To this extent, I've developed the columns:

Weekday = WEEKDAY([Data]-1) 

Day of Week Name = FORMAT([Data], cp01[Weekday] & "_" & "ddd")

As day "Day of Week Name" is text I would like to keep the ordering also without concatenating the weekday as text, but showing only the name of the week day. 
Thank you.

[Anonymous]

Thank you for you answer!
Instead, for the date filter starting the week on sunday? Otherwise the data that is shown for sunday(t) is the one of Week(t-1).

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

I'm not sure about your problem.

If you want to filter the data from Monday to Saturday of the current week, you can try this:

iscurrent_week = IF(YEAR('Table'[Date])=YEAR(TODAY())&&WEEKNUM('Table'[Date],2)=WEEKNUM(TODAY(),2)&&'Table'[weekday]<7,1,0)

If you want Sunday data to be displayed as Saturday data, you can try this:

Column = IF('Table'[weekday]=7,CALCULATE(MAX('Table'[Date]),FILTER(ALLEXCEPT('Table','Table'[Date].[Year],'Table'[weeknum]),'Table'[weekday]=6)),'Table'[Date])

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

That's what I was looking for:

If you want to filter the data from Monday to Saturday of the current week, you can try this:

iscurrent_week = IF(YEAR('Table'[Date])=YEAR(TODAY())&&WEEKNUM('Table'[Date],2)=WEEKNUM(TODAY(),2)&&'Table'[weekday]<7,1,0)

 Thank you very much!

[Fowmy]

@Anonymous 

You have an optional parameter on WEEKDAY to choose when the week starts. your formula could be

Day of Week Name = WEEKDAY([Date] , 2 ) &"_" & FORMAT([Date] , "Ddd")