Forum Discussion

Highlander_'s avatar
Highlander_
Frequent Visitor
8 years ago

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 ...
shebr's avatar
shebr
Resolver III
8 years ago

Hi Highlander_

 

There is a fantastic video that creates you a date table in seconds. What this allows you to do is set your start and end date and also let you amend at any time.   https://youtu.be/vJ7xNUK8sQE

 

 

Give it a go, replace your current table if its only a date table and start a fresh, sometimes its the best way.

 

Thanks

 

shebr

  • Highlander_'s avatar
    Highlander_
    Frequent Visitor
    8 years ago

    Many thanks for taking the time to post this, I'll try this one out.

    Kind regards

    highlands

     

     

  • Highlander_'s avatar
    Highlander_
    Frequent Visitor
    8 years ago

    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.

     

     

     

     

     

    • Highlander_'s avatar
      Highlander_
      Frequent Visitor
      8 years ago

      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?