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

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.

Reply
Anonymous
Not applicable

Related Tables with a DAX Created Table

Dear friends,

 

I am new to Power BI but I learnt a lot with the messages. By now, I need your help. I want to retrieve a column of a table (Table: Cierre, Column: Mes.Cierre), but with the RELATED function I do not get any options, even though those tables are related.

Related Table.PNG

 

 

Link Power BI

https://www.dropbox.com/s/s025irtm9i0b5mn/DC%20Net.pbix?dl=0 

 

I think that is because the table I want to relate was created with a DAX Vcalendar. 

Please, I really appreciate your answers

1 REPLY 1
Anonymous
Not applicable

@Anonymous  - 

The relationship is 1-Many - 1 row in Tabla2 = Many rows in Cierre. Therefore, you can't lookup a single value in Cierre with RELATED. You can use RELATEDTABLE to get the relevant rows. What exactly are you trying to retrieve?

I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.
Nathan Peterson

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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