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.
Hi,
This is regards to the MoM, QoQ & YoY calcialtion of Variance,Financial Year starts from April. attached is the data Format.
Just similar to above i ve a data since FY14 till date.
Note:
1.Fy starts from April
2. Clients are duplicated in each month along with revenue.
Need to calcualte variance MoM, QoQ and YoY in the format below:
Please help me at the earliest,
REgards,
varun
Solved! Go to Solution.
hi, @Anonymous
Just change the table visual to matrix visual and drag Financial Year field into Columns value.
See this pbix file as below.
Best Regards,
Lin
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |