Forum Discussion
Date Table - Generated
Hello, I am faily new to Power tools such as Pivot/BI etc. I just wonderd if anyone could help with this one; I have a relatively large data set that for some reason or another is missing data for ...
Hi,
Very easy to follow with PowerQuery and customised as required, thank you for this - really helpful.
I confess I am still curious about handling orginal problem with DAX - this must happen so often surely there has to be a way of using a function along the lines of Allnoblankrows, handling slicers too.. I feel it's the only way I am going to learn.
Just to add that use of time intelligence functions (use of dateadd function) hgihlights this problem, there has to be a workaround surely?
Any gurus?