Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

do relations between two table

Hi, I have a doubt of how can i do the next work in power bi desktop. I have this two tables and i need to create relation between them. 1st table: ID account range description 1 [655789...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , remove [ and ]

split the columns | into rows 

and slit the column with .. into two columns

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

 

 

Now where the value in null the second column copy the value from first column,

 

You will range for each column  (column 1, column 2)

 

 

then ty between join in power query

https://radacad.com/dates-between-merge-join-in-power-query

 

 

 

or crossjoin and filter in dax

 

filter(crossjoin(Table1,Table2), table2[account] >= Table1[Account1] && table2[account] <= Table1[Account2])

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks amitchandak,

    I understand what you say to me but this example is only for the case that the table one column have a range of accounts separated by .. . What appens when only have one account or 3 specific accounts separated by | the situation in this cases is different?

    Regards,