Forum Discussion

Anmolgan's avatar
Anmolgan
Post Prodigy
6 years ago

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

 

https://ifitech-my.sharepoint.com/:x:/g/personal/anmol_ganju_ifi_tech/EaDkdpHCUBlMseOWwb1mV-EBSs_YC2SxwQk7EvJ5qI2fVQ?e=Pp9Obk

2 Replies