Forum Discussion

mithiladas02's avatar
mithiladas02
Icon for Helper I rankHelper I
5 years ago

Colum Header time period matrix

My matrix table in power bi is just like that. Every tuesday i have to refresh the dataset. the weekday is saturday to friday. how do i update my date when i update the data automatically in column h...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

mithiladas02 , For Saturday week you can get

2.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-Power-BI-Turning/ba-p/1187482

 

Using the start Week snd end week create

 

Week Type = Switch( True(),
[start week]<=Today() && [end date]>=Today(),"Current Week" & format([start week], "mm/dd") ,
[start week]<=Today()-7 && [end date]>=Today()-7,"Last Week" & format([start week], "mm/dd") ,
[Week Name]
)