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,
I have created for the finance department a balance sheet and income statement in LCY. For this I am using the given amount from the tables.
Now they have raised the question if it's possible to convert the LCY to EUR (reporting currency). I have done this before in different report and used normally a calculated column to calculate the value per amount. This is necessary before the amounts in the income statement needs to be calculated against the average exchange rate per selected month.
My Question is: Can I use the same dataset and add a calculated column but don't use it in all the linked report to this dataset. When a report is linked but is not using the calculated column. Will this column then calculated?
I hope it doesn't calculate it, because that will speed up the requesting time!
Hopefully someone knows the answer.
Thanks in Advance!!
Solved! Go to Solution.
Hi @Anonymous ,
calculated columns are calculated after the data load.
Only measures are calculated during the request time.
Please give Kudos for support.
If I answered your question, please mark my post as solution, this will also help others.
Looking for German Power BI content? Visit my blog.
http://www.thinkbi.de/
Hi @Anonymous
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Hi @Anonymous ,
calculated columns are calculated after the data load.
Only measures are calculated during the request time.
Please give Kudos for support.
If I answered your question, please mark my post as solution, this will also help others.
Looking for German Power BI content? Visit my blog.
http://www.thinkbi.de/
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |