Hi, I have two merge two tables. In one table it contains Date and Cost Price on a daily basis. In next table, it contains Date and Margin on monthly basis. I need to write a command so that, I can merge two tables and get an output as shown in the figure.
The margin value is on monthly basis, I need the same margin value to be entered on all the dates for that particular month. And i will create a new column and multiply Margin & Cost Price for my business use.
Can anyone guide me to bring the required Solution/Output in PowerBI?
Hi @balaji90540,
You can open Query Editor, click the Merge Queries as New to merge those two tables:
Then expand the column to get below results:
Click Fill -> Down get expected results.
Create a custom column use formula below:
For detail information, please download the attached pbix file to have a look.
Best Regards,
Qiuyun Yu
Hi @balaji90540,
You can open Query Editor, click the Merge Queries as New to merge those two tables:
Then expand the column to get below results:
Click Fill -> Down get expected results.
Create a custom column use formula below:
For detail information, please download the attached pbix file to have a look.
Best Regards,
Qiuyun Yu
Helpful resources
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Community Update - March 2026
Check out the March 2026 Power BI update to learn about new features.
