Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Andreas-PowerBI
New Member

Grap information of a row, by condition

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 🙂

 

Screenshot 2020-10-14 140126.png

 

2 REPLIES 2
Ashish_Mathur
Super User
Super User

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
lbendlin
Super User
Super User

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?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.