week data

[Anonymous]

hiii

i usethis formula to display my data as per month but now i want display my data as per weeks

how can i do

[amitchandak · Accepted solution]

@Anonymous ,For week you have WEEKNUM([Date],2) or WEEKNUM([Date],1)

////////////////////////////////////

Typically We Join the date (call closed) with date table. There we will date , month, week , year etc and we will group date in visual by that.

In case of date has a timestamp. Then we create the only date

call closed Date = [call closed].date

You can have column in your date table

Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")

Year = FORMAT([Date],"YYYY" )

Qtr No = FORMAT([Date],"Q")
Qtr = FORMAT([Date],"YYYY") & "-Q" & FORMAT([Date],"Q")	

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)
Week Number = WEEKNUM([Date],2)
Week Rank = RANKX(all('Date'),'Date'[Week Start date],,ASC,Dense)	

https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions


Appreciate your Kudos.