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

 

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!