Forum Discussion
Percentage Increase Previous Years Concatenated Matrix Table
Hi All,
Having difficulties solving this. Appreciate everyone's help and efforts. Thanks in advance.
Table
| Week No | year | Amount |
| 1 | 2019 | 100 |
| 2 | 2019 | 200 |
| 3 | 2019 | 300 |
| 1 | 2020 | 500 |
| 2 | 2020 | 600 |
| 3 | 2020 | 700 |
| 1 | 2021 | 600 |
| 2 | 2021 | 850 |
| 3 | 2021 | 900 |
Desired Output - Matrix Table
| Week No | 2019 | 2020 | 2021 |
| 1 | x | x | 500%, 20% |
| 2 | x | x | 325%, 42% |
| 3 | x | x | 200%, 29% |
I want each year to show the percentage increase/decrease of the previous two years concatenated
Thanks. 🙏
Anonymous , if the above three are measured you can create two measures and concat those
This Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))Last to Last Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))
diff % = divide([This Year]-[Last Year ],[Last Year ])*100 & "% , " & divide([Last Year]-[Last to Last Year ],[Last to Last Year ])*100 & "% "
Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA
3 Replies
- amitchandak
Super User
Anonymous , if the above three are measured you can create two measures and concat those
This Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))Last to Last Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))
diff % = divide([This Year]-[Last Year ],[Last Year ])*100 & "% , " & divide([Last Year]-[Last to Last Year ],[Last to Last Year ])*100 & "% "
Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA HOW CAN I CALCULTE PERCENTAGE INCREASE OF NUMBER OF EV VEHICLES AND EV CHARGERS ON POWER BIHOW CAN I CALCULATE THE PERCENTAGE INCREASE IN NUMBERS OF ELECTRIC VEHICLES AND EV CHARGES PER YEAR?
