Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Calculated column based on date slicer selection

Hi folks,   I just read the following article (http://community.powerbi.com/t5/Community-Knowledge-Base/Calculated-Column-Table-Change-Dynamically-According-to-Slicer/ta-p/163321) which makes me be...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi Anonymous

What are your tables like?

I create an example, is it right?

table1

 

table2

 

I am testing, if i have misunderstood you, please let me know in time.

 

Best Regards

Maggie

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hello,

 

I have found a solutiuon after reading a new book on PBI :)

 

I used the unpivot column function in my original table and duplicated all lines, with one new column showing each singular value.

 

My lookup was then used on this specific column and all functionalities worked.


Thanks everyone and Maggie for your assistance :)

 

OF