Creating a TODAY() dimTIME table from 00:00:00 to ...

Anonymous · ‎09-02-2021

Hey all - I'm looking to create a dimTime table to create a couple of visuals based on the time, and most importantly HOURS of the day - just seeing either "0, 1, 2...23" or "0:00:00, 01:00:00, etc."

I'm not exactly sure how to go about this one. If anyone has done anything similar, please provide your expertise.

CNENFRNL · ‎09-02-2021

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!