Pull Multiple Records into a Calendar Table

[pedanticpad]

Hi,

I have a calendar table and another table with multiple records for each date.  I need to pull the records into the calendar table so that i would have something like the below;

01/01/20   Mr x 10 Hrs

01/01/20   Mr y 20 Hrs

01/01/20   Mr z 12 Hrs

01/02/20

01/03/20   Mr x 15 Hrs

I can do it easily in MS Access but I can't figure out how to do it in PowerBI.

Thanks for your help!

[v-lionel-msft]

Hi @pedanticpad ,

You can do it by "Merge Queries" feature.

Best Regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

In the date table, you have one row for a date. Not sure How you want to make multiple rows. When you display in visual it will repeat as many time ungrouped items are there.

Now to put in one table from another table. Example: here new column is created in item table

Max Sales date= Maxx(filter(sales,Sales[item_id]='Item'[Item ID]),Sales[Order Id]) 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601