Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.

I would like to build a table that has all dates and prices for different things on different dates

 

Date  |  Price_A  | Price_B  |  Price_C

 

I have a Date table build with every Date in it.  I would like to get calculate a table with all dates, Price_A from Price_A table where it matches the Date table, get Price_B from Price_B table where it matches the Date table, get Price_B from Price_B table where it matches the Date table, etc.  

 

I would expect a table with every date and for the most part a price in each of the A, B, and C columns, but not necessarily (i.e. some prices don't post on holidays).

 

Thanks you in advance! 

 

 

1 ACCEPTED SOLUTION

@Anonymous,

 

You may take a look at https://www.sqlbi.com/articles/lookup-multiple-values-in-dax/.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-chuncz-msft
Community Support
Community Support

@Anonymous,

 

Add relationships to the Date table, then you may simply drag the fields to a Table visual.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

They are related.

@Anonymous,

 

You may take a look at https://www.sqlbi.com/articles/lookup-multiple-values-in-dax/.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.