Forum Discussion
tonijj
Helper IV
2 years agoHasoneValue and VAR combo
Hi,
So I searched the forum, and didnt find this particular issue.
What I want to achieve:
- A measure including Hasonevalue function to divide the Sales by e.g. EUR, KEUR or MEUR.
- For the value to be able to divide by the above (Thousands, Millions) I first want to do a simple calculation of "Sales X FX Rate) as some of the numbers are in different exchange rates
What I have:
- Attaching a simple Excel sheet with the data and PBIX file
What I have managed:
- Create a measure with the Hasonevalue function if its only the source data "Sales".
What I need help with:
- Create a measure that not only uses the Hasonevalue function BUT as a first also takes: "Sales value X Fx Rate".
1 Reply
- Irwan
Super User