Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Get Varience on Matrix

Hi,   The below code does not seem to work, I can bring in the matrix details fine, but when I am trying to say give me last years value (Same PeriodLastyear) based on the filter it does not work. ...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    Anonymous

     

    We can mark relationships as inactive to reduce ambiguity in Power BI as below.

     

     

    Best Regards,

    Herbert

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Its ok Herbet,

 

I spoke to someone from PowerBi who says you cant have indirect relationship between tables, so not sure how it can be done in PowerBI

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
10 years ago

Anonymous

 

For relationships in Power BI, please refer to this document.

To see if we can get your expect result, we need the sample data of your tables.

 

Best Regards,

Herbert

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Herbert,

     

    It seems you cannot not have inactive relationships in PowerBi, someone will hopefully come up with a grpahic in R or something.

     

    Thanks

     

    Chris

    • v-haibl-msft's avatar
      v-haibl-msft
      Microsoft Employee
      9 years ago

      Anonymous

       

      We can mark relationships as inactive to reduce ambiguity in Power BI as below.

       

       

      Best Regards,

      Herbert

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Thanks will have a look into that!