Thursday, 5 June 2014

Note to Self: Some useful DAX commands which I keep forgetting

Over time, I will add to this list. I want to keep an online copy of DAX commands so I can copy and paste them for future Power Pivots.

When you have an integer and want to convert it into HH:MM or HH:MM:SS format
=FORMAT(TIME(0,0,'CiscoData'[queuetime]),"hh:mm:ss")

This list will grow over time. I just got fed up with forgetting this one!
Post a Comment