Forum Discussion
MOM, QoQ, YoY calculation
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
Community Support
hi, Anonymous
You need to add a Financial calendar table and then create the relationship with data "Month" column.
Then use DATEADD or PREVIOUSMONTH Function to calculate previous month data as below:
Measure = CALCULATE(SUM('Table'[Sales]), DATEADD('FY calendar'[Date], -1, MONTH))
or
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.
Best Regards,
Lin
Hi All,
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
- Ashish_Mathur
Super User
Hi,
Share some data in a format that can be pasted in MS Excel.
Hello Ashish,
Sorry, could not attach the file in this portal. Please find the view of the data.
REgards,
Varun
- Ashish_Mathur
Hi,
Paste the data in the body of the message.
