Forum Discussion
Getting Values From 2 different tables using measure
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.
2 Replies
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
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.
