Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am new to Power BI. I want to find the MAT(Moving Annual Total) . I got result using below calculation in Table.
MAT (moving annual total) = CALCULATE(
SUM(TransactionData[Revenue]),
DATESINPERIOD(CalenderDate[Date],LASTDATE(CalenderDate[Date]),-1,YEAR)
)
But i want result in MATRIX format (ie) Each DATE Months are separated column. how to find it.
Eg Prod Jan Feb Mar
abc 50 150 200
efg 70 50 100
xys 120 300 400
Can you post example source data? Seems like you could put your formula in a measure versus a calculated column and achieve what you are looking for. Please try not to cross post. I have no idea if anyone has replied to your two or three other posts on this subject.
I am new to Power BI. I want to find the MAT(Moving Annual Total) . I got result using below calculation in Table Format.
MAT (moving annual total) = CALCULATE(
SUM(TransactionData[Revenue]),
DATESINPERIOD(CalenderDate[Date],LASTDATE(CalenderDate[Date]),-1,YEAR)
)
But i want result in MATRIX format (ie) Each DATE Months are separated column. how to find it.
Eg Prod Jan Feb Mar
abc 50 150 200
efg 70 50 100
xys 120 300 400
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |