Forum Discussion
DAX to pickup values dynamically?
I want to basically multiply my royalty on my spreadsheet with the sales volume, with respect to the months that is some other field coming from some other query and my customer groups that are also in the same query where my months are present.
For Example If I select Sales Group: Channel Sales OEM/FWS, Customer Group: FORCE MOTORS AVD, Month/Year: Apr 2019, then my Sales Volume DAX should give me Royalty of that month and year multiplied by the Sales Volume KL. Is that possible?
here is my PowerBI and Spreadsheet link: https://ifitech-my.sharepoint.com/:u:/g/personal/anmol_ganju_ifi_tech/EeTeblYp0jJLsEIcvOk6q-cBBxJBHWPl04IiXVMzyx2ZcA?e=WEqvbO
2 Replies
- v-easonf-msftCommunity Support
Hi, Anmolgan
The link you provided is no longer valid. Please reshare your sample pbix file and Spreadsheet for us to have a test.
Best Regards,
Community Support Team _ Eason
- AnmolganPost Prodigy