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.
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,
Solved! Go to Solution.
Just change the table visual to matrix visual and drag Financial Year field into Columns value.
See this pbix file as below.
You need to add a Financial calendar table and then create the relationship with data "Month" column.
Measure = CALCULATE(SUM('Table'[Sales]), DATEADD('FY calendar'[Date], -1, MONTH))
Measure = CALCULATE(SUM('Table'[Sales]), PREVIOUSMONTH('FY calendar'[Date]))
Then drag date field from Financial calendar table into visual
If not your case, please share some simple and complete data with your expected output.
After some workout on the data there are some findings as mentioned below:
1. As mentioned, my fianncial Yaer starts from April to Mar and 've a data from FY14.
2. Used All select Month name to filter but could not get
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!
Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications