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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

This is indeed the end result I'm looking for, but I'm running into a problem following the steps laid out in your sample PBIX file. When attempting to join the warehouse data to the final table (using the warehouse data in place of your sample data), I get all null values in the merged columns and I am not sure what I am doing wrong. I've made sure to match the merged data types to what's in the warehouse data, including with the merge key on both tables. Is there something else I'm missing?

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

Hi Anonymous,

 

The unique identifier might not be strong enough and thus returning black results? Try to go the other way around by changing the sample data with a few of your real data and see if you get the right results.