Forum Discussion

pedanticpad's avatar
pedanticpad
Icon for Helper II rankHelper II
6 years ago

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 ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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/823601