Calculation to display specific dates on a card - previous workday

[benjaminhoang]

Hey Guys,

I have a card that currently pull data from excel sheet with a date and and amount. I currently manually change the day to show previous days amount. The problem I am having is I want this automated to show

for Monday it will show friday, saturday and sunday

Tuesday will show monday

Wednesday will show tuesday

Thursday will show wednesday
Friday will show thursday

[v-chuncz-msft · Accepted solution]

@benjaminhoang,

You may use WEEKDAY Function in nested IF Function or SWITCH Function to add a measure.

http://community.powerbi.com/t5/Desktop/How-to-display-total-document-number-for-last-month-data-bas...