Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 🙂
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.
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?
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |