cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
iruijs Frequent Visitor
Frequent Visitor

calculated column in Dataset, but not in every report

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!!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Re: calculated column in Dataset, but not in every report

Hi @iruijs ,

 

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/

 

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Proud to be a Super User!

View solution in original post

2 REPLIES 2
Super User III
Super User III

Re: calculated column in Dataset, but not in every report

Hi @iruijs ,

 

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/

 

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Proud to be a Super User!

View solution in original post

Super User III
Super User III

Re: calculated column in Dataset, but not in every report

Hi @iruijs 

 

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Proud to be a Super User!

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors