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 V
Super User V

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 V
Super User V

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 V
Super User V

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 Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors