Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |