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,
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] ))
Ah, you're right, thanks! I had also tried a measure using CALCULATE with filter arguments instead of just using FILTER.