Forum Discussion
Entry in visual for each day, based on date table
- Open the Power BI report and go to the Home tab.
- Select the Edit Queries button to open the Query Editor.
- In the Queries pane, right-click on the Run table and select Reference.
- Right-click on the Date table and select Join.
- In the Join dialog box, select the Left outer join option.
- Select the Date column from the Date table as the join column.
- Select the Start Date column from the Run table as the join column.
- Click OK to create the join.
This should create the left outer join between the Run table and the Date table, and you should see all the dates from the Date table in the report visual, even if there was no run on that date.
Make sure that the date column in the Run table is in the correct format, that it is a date, and that the date column in the Date table is in the same format, it could be possible that the join is not made properly because of the format issue.
I think your steps were not fully correct but I managed to do it 🙂
the steps i took:
1. reference run table
2. merged 2 tables, the date table in the top, and run table as second table, than left outer join.
Now i have indeed the two tables together, with all the dates of the date table.
Question: since my run table gets updated via odatafeed almost daily (when there has been a run), will this merged table get updated as well?