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.
Hello All,
I want to create a calculate column where just want to create average monthly currency exchange rate from daily.
Please see screeshot below where we have daily average currency exchange rate and also here you will see single currency in FROMCURRENCY and the same in TOCURRENCY but we have multiple currencies in both the columns.
Below is the expected result to be shown.
Can anyone help me on this?
Thanks
Solved! Go to Solution.
Hi @abhayrnjn ,
On the Query Editor Select the Group by and then do the grouping by:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix,
I tried your solution but didn't work to me. So i had used below dax to get the expected result.
Thanks for your help.
Hi @abhayrnjn ,
On the Query Editor Select the Group by and then do the grouping by:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |