Calculated Columns not refreshing [SOLVED]

Anything related to PowerPivot and DAX Formuale
imrsk
Posts: 2
Joined: Tue Dec 24, 2019 1:41 am

Calculated Columns not refreshing [SOLVED]

Postby imrsk » Tue Dec 24, 2019 1:50 am

Hi All,

I am totally new to this and I searched the forum in order to find the answer for this but I could not...

So, here is my question.

I have two data bases:

1) DATA BASE: a link between Old product name and New product name :

Example:

Sneakers 1000 = BoostShoes

2) DATA BASE: sales but using old product name

Example:

Seakers 1000 = 120 sold

Now, I wanted to create a calculated column that would translate the old product name into new product name directly in the sales report.

With a vast majority it works. But there are few lines that even though they appear in the first data base and there is no typos, it just does not refresh! So I get:

Sneakers 1000 = 120 sold = BoostShoes (LookUpvalue effect)
Jacket 500 = 450 sold = ???? (no value looked up even though there is a relation of Jacket 500 to SuperJacker in my data base).

Any idea why that happens to some cases only??

Thanks!!!!
Imrsk
Last edited by imrsk on Fri Jan 03, 2020 8:05 pm, edited 1 time in total.

RamanaV
Posts: 53
Joined: Thu Oct 19, 2017 12:57 pm

Re: Calculated Columns not refreshing

Postby RamanaV » Tue Dec 24, 2019 9:37 am

I don't think you need a calculated column to solve this.
You can merge the data in Power Query before loading it into data model and then it works.

If you are not sure how to do it, please share a sample workbook.
I will show you the solution.
Ramana Varanasi
Training and Office Manager
Excelerator BI Pty. Ltd.

imrsk
Posts: 2
Joined: Tue Dec 24, 2019 1:41 am

Re: Calculated Columns not refreshing

Postby imrsk » Fri Jan 03, 2020 8:04 pm

Hello,

Thank you very much for your response, RamanaV! It worked perfectly fine and it´s solved now! :)

Big thanks,
imrsk

sophiabrar
Posts: 2
Joined: Mon Jan 13, 2020 12:01 am

Re: Calculated Columns not refreshing [SOLVED]

Postby sophiabrar » Mon Jan 13, 2020 12:23 am

Hello -
I just started this book. Could you share the link to the dataset?
the one in the book and the one of the website are both broken.
https://exceleratorbi.com.au/power-bi-online-training/ (containing the Adventure works database download).


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 1 guest