Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Hello friends, I appreciate the help of the Power Bi community to recommend the way to insert a column in a matrix and calculate the percentage of variation between values of different, I have sought help with similar cases but I have not been able to find what I am looking for, I would appreciate any help you can give me, share image of the matrix with the values I want to calculate the variation, for example on 7/06/2022 in the Vivero Mujeres the plant 1 measured 25 cm and on 21/06/2022 that same plant measured 35 cm, if I use a mathematical formula (35-25)/25 I have as a result 40% variation, how can I calculate this in Power Bi?
Greetings and thanks.
@Syndicate_Admin , using a date table and date from date table is used on column of matrix
Try a measure like
[Measure] = calculate(lastnonbalnkvalue(Date[Date], [measure] ), filter(allselected(Date), Date[Date] = Max(Date[Date])))
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 57 | |
| 53 | |
| 40 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 116 | |
| 105 | |
| 41 | |
| 34 | |
| 25 |