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
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.