Sat Dec 30 2023 07:11:01 GMT+0000 (Coordinated Universal Time)
Saved by @nikahafiz #ms.pbi #dax #dax.weeknum
Week Number = WEEKNUM( [Date], 2 )
#dax #tabular.editor #live.dataset #ms.pbi #dataset
foreach (var m in Model.AllMeasures) { m.Description = m.Expression; }
#ms.pbi #dax #dax.calculate #dax.filter #dax.all #dax.in
CALCULATE( [Revenue], FILTER( ALL( 'Calendar'[Year] ), 'Calendar'[Year] IN { 1996, 1998 } ) )
#ms.pbi #dax #dax.lookupvalue
LOOKUPVALUE( Products[UnitPrice], PRODUCTS[ProductID], ORDER_DETAILS[ProductID] )
#ms.pbi #dax #calendar.table #dax.addcolumns #dax.var #dax.return #dax.format #dax.month
Calendar = VAR CalTable = CALENDARAUTO () VAR MyCal = ADDCOLUMNS ( CalTable, "Index", MONTH ( [Date] ), "Month", FORMAT ( [Date], "mmm" ), "Qtr", FORMAT ( [Date], "\QQ" ), "Year", FORMAT ( [Date], "yyyy" ) ) RETURN MyCal
#ms.pbi #dax #calendar.table #dax.quarter
QtrNo = "Q" & QUARTER( 'Calendar'[Date] )
#ms.pbi #dax #calendar.table #dax.weekday
Week EndDate = 'Calendar'[Date] + 7-1*WEEKDAY( 'Calendar'[Date], 2 )
Week StartDate = 'Calendar'[Date] + -1*WEEKDAY( 'Calendar'[Date], 2 ) + 1
#ms.pbi #dax #calendar.table #dax.rankx #dax.asc #dax.dense #ranking #week.rank
Week Rank = RANKX( ALL( 'Calendar' ), 'Calendar'[Week StartDate], , ASC, Dense)
#ms.pbi #dax #calendar.table #dax.weeknum
WeekNo = "W" & WEEKNUM( 'Calendar'[Date], 2 )
#ms.pbi #dax #calendar.table #dax.format #dax.calendar #format-ddd
DayName = FORMAT ( 'Calendar'[Date], "ddd" )
#ms.pbi #dax #dax.weekday #calendar.table
DayofWeekNo = WEEKDAY ( [Date], 2 )
#ms.pbi #dax #calendar.table #dax.day
DayofMonthNo = DAY ( 'Calendar'[Date] )
#ms.pbi #dax #calendar.table #week.no
YearWeekNo = 'Calendar'[Year]*100 + 'Calendar'[WeekNo]
#ms.pbi #dax #calendar.table #dax.switch #dax.true #dax.month #quarter
Qtr = SWITCH( TRUE(), MONTH('Calendar[Date]') <=3, "Q1", MONTH('Calendar[Date]') <=6, "Q2", MONTH('Calendar[Date]') <=9, "Q3", "Q4" )
#ms.pbi #dax #dax.topn #ranking
Best Selling Day/Date = TOPN( 1, 'Calendar', [Total Sales] )
Copy this HTML code:
Preview:
open_in_newInstructions on embedding in Medium
Comments