SelectRows function

[math2841]

Dear Power BI Experts,

In my Power BI report i would like to create relations between my different NAV queries, based on the global dimension.

In order to avoid a many to many relation i created a query with my global dimensions as seen below.

I would like to create a table for each "global dimension no" as described in the following link:

https://www.linkedin.com/pulse/dealing-dimensions-hooking-power-bi-up-microsoft-marghi-cpa-cga

I tried to use SelectRows but im left with an error:

 I hope you can help me understand what im doing wrong and how i can accomplish my goal. 

I also tried using group by, but it left me with the following table.
If i click on Table in the picture below, i will se my desired result but i do not have one table for each global dimension no. 

I hope you can help me.  

[v-yuta-msft]

Hi math2841,

The syntax of table.selectrows seems to be wrong in your screenshot. You should follow the format like 

Table.SelectRows(table as table, condition as function) as table

Please refer to: https://msdn.microsoft.com/en-us/query-bi/m/table-selectrows

Regards,

Jimmy Tao

[Anonymous]

Thanks for the reply v-yuta-msft.
I found a workaround by using LOOKUP.