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

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

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

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

@New2BInow,

 

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
Community Support Team
Community Support Team

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

@New2BInow,

 

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.
New2BInow Frequent Visitor
Frequent Visitor

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

They are related.

Highlighted
Community Support Team
Community Support Team

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

@New2BInow,

 

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 48 members 1,017 guests
Please welcome our newest community members: