The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I have one table(FactPrice) with the Product price list column, product name column, mobile no column, and another table(FactQuanity) with Product Quantity column, Mobile no column. i want to divide the price column from this Factprice table with the quantity column of the factQuantity table.
How to do it?
Thanks in advance
Solved! Go to Solution.
Try this if you are using product id as row
Sample Data I used
Table Relationship
(Ignore bi-directional relationship since its sample file) single direction is recommended
Thanks for your reply. it solved my problem
Try this if you are using product id as row
Sample Data I used
Table Relationship
(Ignore bi-directional relationship since its sample file) single direction is recommended