In one of my recent data visualization projects I’ve had the need to generate the dense rank for a set of data after splitting them into horizontal groups. I’ve come up with the logic in DAX to find the dense rank…
DAX DATE function demystified
I was working intensively last few days on DAX and DATE() was one of the functions I used quite a few times. I was confused initially on how DATE() function works and it took me a while before I understood…
Date and Time functions in DAX extended
I was working on DAX project during last few days and found out something strange. Though DAX function set has some of very advanced date/time based functions like DATESMTD,DATESQTD,etc it lacks a few basic functions like QUARTER(). As this is…