Snippets Collections

Recent | Popular

view_listList view view_moduleGrid view
content_copy

#ms.pbi #dax #calendar.table #dax.switch #dax.true #dax.month #quarter

DAX | Quarter No - 2 
Qtr =

SWITCH(
	TRUE(),
	MONTH('Calendar[Date]') <=3, "Q1",
	MONTH('Calendar[Date]') <=6, "Q2",
	MONTH('Calendar[Date]') <=9, "Q3",
	"Q4"
)

DAX | Quarter No - 2
star

Sun Dec 24 2023 07:39:01 GMT+0000 (Coordinated Universal Time)

#ms.pbi #dax #calendar.table #dax.switch #dax.true #dax.month #quarter

Save snippets that work with our extensions

Available in the Chrome Web Store Get Firefox Add-on Get VS Code extension