The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have two tables Order Table and Returns Table, I want to calculate return rate using of DAX
@PBIBALU , Assume you have common dimensions like Date, Order, Geography , Article/Item , customer etc
You can create a new measure like
divide( sum(Return[Qty]), sum(Order[Order Qty]))
or
divide( Count(Return[Qty]), Count(Order[Order Qty]))
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the July 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
109 | |
68 | |
46 | |
42 |
User | Count |
---|---|
188 | |
86 | |
77 | |
74 | |
60 |