Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear all,
i have an situvation were i need to join two tables and calculate value based on codition and fill the new value to another category.
if you see the first table, i have kep 0 for the category "Sales Online" which i need do the sum of all lead_number count and do the sutraction where source key =10
any idea.... i have tried Switch but didnt help me..
Thanks
Hi @SEPA,
I think you can take a look at the following blog to create a formula based on calculated group if help with your scenario:
Matrix In Power BI Using Calculation Groups - Enterprise DNA
Regards,
Xiaoxin Sheng
Actually, the right table is my dimension table and the left table coming from fact table.. i need to do the subtraction the lead count where source key=10 and get that value and assign to Sales online category
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |