Getting Workday : Table

[Chandrashekar]

Hello Team,

How to get workday in Table. For Ex:

if it is Monday ( I need to get last week dat from Mon to Fri)

If it is Tuesday ( I need to get date(Tue, Wed, Thu, Fri and Mon)

Regards,

Chandrashekar B

[amitchandak · Accepted solution]

@Chandrashekar , Please refer this blog. I given for code for all 7 days

Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...

or the file attached after signature