Getting Values From 2 different tables using measure

[mussaenda]

Can somebody teach me how to get the values from column by using measure?

I have Table 1, Table 2 and Selection.

the Logic is, If selection = 1, show the date from table1

if selection = 2, show date from table2

else, show date1 && date 2

Also,

I have $/kg from both tables.

Same logic as above. I don't want to aggregate them unless I did not choose anything from the selection table.

Thank you for the help.

[tjlee]

Dynamic column is not possible currently, if this was a measure then it is possible.

You could achieve something similar using the technique mentioned in this blog 

How to do multivariate reporting with Power BI

https://powerbi.microsoft.com/en-us/blog/how-to-do-multivariate-reporting-with-power-bi/

It involes using slicer button and assigning favorites with different columns in a chart object.

[MFelix]

Hi @mussaenda ,

Can you please add more information about your question?

Please see this post regarding How to Get Your Question Answered Quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 (courtesy of @Greg_Deckler).

Regards,

MFelix