Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.

 

 

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

Tips and Tricks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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