Grap information of a row, by condition

[Anonymous]

Hello community,

I could need some help in a case 🙂 

We have 3 Tables A,B and C. A ist related with C over B. 

I would like to have the information of Result from C in conditions to the DocumentDate, if DocumentDate from A is between FROM and TO of table C. 

Should I use a costum column or a measure? And I need help with the formular 🙂 

Many Thanks, Andreas 🙂

[Ashish_Mathur]

Hi,

You will have to write 2 calculated column formulas in Table A - one to bring over the contents of BC column from Table B (using the RELATED() function) and another to bring over the contents of the Result column from Table C (using the CALCULATE() and FILTER() function).

Hope this helps.

[lbendlin]

Think of it in terms of "Dimensions"  (things you filter by) and "Facts" (stuff you calculate).  Is A a dimension table or a fact table?