This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 16%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
I have a tabular model in SSAS that has a DateDim table that has a relationship to a fact table, which holds appointment data. The ultimate goal is to pull this data into Power BI Report Builder, so I would like to get this as 2 dataset if possible. The SQL query I am trying to recreate is
SELECT *
FROM DateDim d
LEFT OUTER JOIN FactTable f
ON d.DateKey = f.DateKey
I would like to return 1 row for every date in the date range I specify, and then 0 to multiple rows from the fact table for those dates. I'm trying to create a calendar that would then show a list of appointments for each day.
Is there a DAX query that I can use to write this? Or any other suggestions?
Thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi @Andy Bolk
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
That should say as a single dataset.
Hi @Andy Bolk
Can this post help you?
https://www.wiseowl.co.uk/blog/s2471/calendar-table.htm
Best regards,
Percy Tang
If the answer is the right solution, please click "Accept Answer". If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.