Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Increase % between two years

Hello, I'm new in this world of Power BI and I need some help. I've been trying to get the increase percentage of sales between 2 years. The sales are in the same column and there's a time dimensio...
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Anonymous

     

    I recreate your tables in a reduce version:

     

    Relationships

     

    And Dax and Results

     

    Dax and Results

     

    You can try to modify Salesof1YearBefore :

     

    Salesof1YearBefore = Calculate([Sales],DATEADD(public_dim_tiempo[Date],-1,YEAR))

v-micsh-msft's avatar
v-micsh-msft
Microsoft Employee
9 years ago

Hi andrea9gutiampu,

 

What is your current situation?

Regarding Matrix, there is no way to remove the first column you marked in the visual. The values shows in that column is for the increase Precent, currently there is no customization available to hide the values that shows no input. For the Totals, we could disable it under the Format pane.

Format->General->Total Column

For the same amount per each city, this could be cuased by that the sales calculated is not associated with the city column(I mean they are not under the same table), or there might be issues regarding the relationships between those tables.

Post back if you need any further assistance.

Regards

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thanks Michael_Shao. It works!