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
Hi All,
Can anyone help for the dax measure for below excel function . we have 50+ merchants , example user has taken officeworks here, i need need to write dax which applies the 50+ merchants
Regards,
Manjula
Hi @TomMartens ,
i need to calculate Total remmitance based on the function provided in excel which is highlighted in screen shot
Total Remmitance = E15+F15+G15+H15+I15+J15-(E13+J13)
WE have all the columns we can add the totals , but my doubt is for E13+J13 user is picking the selected schema i,e officeworks giftcard and adding the E13 row and J13.. how to achieve this
Hey @Manjula ,
I have to admit that I do not understand your requirement.
In Power BI Desktop you can use the column merchant with a slicer visual, simply drag one of the numeric columns like GROSS SALES to a table visual and Power BI Desktop will automatically aggregate the values inside your table.
Hopefully, this provides some ideas on how to tackle your challenge.
Regards,
Tom
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 |
---|---|
115 | |
112 | |
69 | |
48 | |
43 |
User | Count |
---|---|
188 | |
87 | |
77 | |
74 | |
60 |