What do you think? For which scenarios do you use the advanced editor? Put your thoughts in the comments below!
DAX has a lot of nice functions to make Time Intelligence with Months and Quarters easy. But what if your company uses its own Calendar with custom months and quarters like in the 4-4-5 or 5-4-4 system?
If you want to do some custom Time Intelligence (like below) or create Calculated Columns in a Date table then this Cheat Sheet can be very handy.
What do you think?Which kind of files do you like to import from a folder and problems did you encouter doing so?Put your thoughts in the comments below!