Forum Discussion
Pull Multiple Records into a Calendar Table
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!
2 Replies
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-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601Hi pedanticpad ,
You can do it by "Merge Queries" feature.
Best Regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
