Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Create rows for missing weekly data

Hello,   A while back, I had a question regarding day of week and time data (app availability). I have since transformed this data using a coworker's SQL script, but have now run into a new issue. ...
Need Help
  • hnguy71's avatar
    hnguy71
    3 years ago

    Anonymous , this can be achieved in multiple ways but I'll try it in PowerQuery.

     

    I believe this is the result you're looking for:

     

    Attached is a sample pbix

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

If you had a Date column in your dataset, this would have been a simple one to solve.  Do you have a Date column?