Forum Discussion
week data
- 5 years ago
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/1051123To 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.
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.