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

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

Anonymous

 

Could you please give some sample data, relationships of your tables and the expected output?

 

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