I need add two colunm of percentage of growth

[Anonymous]

Hello, add two columns calculated but with (if) and the result is not as expected, it is possible that someone can do me the favor of helping me with DAX forms, I would like to calculate the percentage of growth of the last month and the year, this is my information that I get from MSSQL.

 

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may try Unpivot Columns in Query Editor and CALCULATE Function to change the context.

• https://community.powerbi.com/t5/Desktop/Year-on-year-for-previous-reporting-period/m-p/326661#M1457...
• https://www.sqlbi.com/articles/filter-arguments-in-calculate/