Forum Discussion
Solved
Display matrix visual with fiscal week
I have requirment where i need to show matrix visual with Fiscal week(starts from Sunday to suturday)
Req:
Year(2019)
Month(April)
Fiscal Week(3/31/2019)
Sunday 3/31/2019
Monday 4/1/2019
..... Saturday 4/6/2019
please help. I checked many blogs unable to get the week result as bove
Hi gopalbbg ,
We can create the calculated columns as below to work on it.
weeknum = YEAR('CALENDAR'[Date]) & WEEKNUM('CALENDAR'[Date],1)Column = FORMAT(CALCULATE(MAX('CALENDAR'[Date]),FILTER('CALENDAR','CALENDAR'[weeknum] = EARLIER('CALENDAR'[weeknum]))),"YYYY-MMM")Column 2 = FORMAT('CALENDAR'[Date],"dddd") & 'CALENDAR'[Date]Pbix as attached.
2 Replies
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi gopalbbg ,
We can create the calculated columns as below to work on it.
weeknum = YEAR('CALENDAR'[Date]) & WEEKNUM('CALENDAR'[Date],1)Column = FORMAT(CALCULATE(MAX('CALENDAR'[Date]),FILTER('CALENDAR','CALENDAR'[weeknum] = EARLIER('CALENDAR'[weeknum]))),"YYYY-MMM")Column 2 = FORMAT('CALENDAR'[Date],"dddd") & 'CALENDAR'[Date]Pbix as attached.
