cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Re: MOM, QoQ, YoY calculation

Hello Ashish,

 

Ideally, my target is to find the difference as shown below.

 

image.png

 

REgards,

Varun

Highlighted
Helper V
Helper V

Re: MOM, QoQ, YoY calculation

Hello All,

 

Please help me with a solution.

 

REgards,

Varun

Highlighted
Super User IV
Super User IV

Re: MOM, QoQ, YoY calculation

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Highlighted
Helper V
Helper V

Re: MOM, QoQ, YoY calculation

Thanks Ashish for your response,

by any chance do we have the possibility to solve this without using  Filters for Financial Year?

 

I mean, possible to find the total of SamePeriod previous Year sales at row level for each Month. Like Sum of all April related sales, May Sales etc...

 

Regards,

Varun

Highlighted
Super User IV
Super User IV

Re: MOM, QoQ, YoY calculation

Hi,

I do not understand your question but for computing same period last year, you will have to select a specific year.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Highlighted
Helper V
Helper V

Re: MOM, QoQ, YoY calculation

I understand.

 

Imean to say in the below Format. Where we can view the Current and Previous numbers for all the months 

image.png

Highlighted
Helper V
Helper V

Re: MOM, QoQ, YoY calculation

I understand.

 

I mean to say similar to the below format ist possible ? where can view the variance for each FY at column level? 

 

image.png

 

Regards,

Varun

Highlighted
Community Support
Community Support

Re: MOM, QoQ, YoY calculation

hi, @chandra_0202 

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 Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Helper V
Helper V

Re: MOM, QoQ, YoY calculation

I'd issue with my file with regards to the Relationships hence i could not get the solution.

 

Thanx Ashish and all for your support

Highlighted
Super User IV
Super User IV

Re: MOM, QoQ, YoY calculation

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors