Forum Discussion
Solved
Create calculated column in Table2 that can be sliced using fields from Table1
My objective is to be able to create a visual (a column chart) with Table2[Arbitrary date] as the X-axis and the Table2[Calculated column] as the Y-axis. I need to be able to have this chart affec...
Hi jbstephenson,
I'm this case you need to create a measure to make the calculation dinamically try the following.
Measure =
=countrows(FILTER(table1 ,table1[date received] >MAX( table2[arbitrary date]) & & table1[date processed] > MAX( table2[arbitrary date] ))
MFelix
Super User
Super UserHi jbstephenson ,
To create a relationship between tables you need to follow this guidance.
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships
But in this case I have some doubts you refer that you want to have a filter on the colour? does this means that you want the calculated table to be dinamic based on selection?
Yes, I need it to be dynamic based on selection