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.
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
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |