Introduction to Power Query language “M”
What do you think? For which scenarios do you use the advanced editor? Put your thoughts in the comments below!
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!