Compare any 2 of anything with Power BI

[@ratanbhushan8839]

you are the only person who has solved this. you are the only. Thank you so much. you are amazing

[@linhlethuynhat4500]

It took me a long time to find the solution and luckily I found this lesson. Thank you for sharing, wish you a lot of luck in life. Hope to see many more useful posts. Grateful, grateful and grateful.

[@carnerocastro]

This video is an authentic treasure! By far, one of the most useful videos that I've ever seen on Power BI (If not THE most) Thanks so much!!

[@erniecortes5453]

coomparison between years is standard reporting practice, hence, there should an easy function to handle this

[@חייםחדד-ח2מ]

One of the most effective and helpful videos of Power BI! Well done and thank you! :)

[@soonmi8278]

THANK YOU. I have tried this so many times in so many different ways and this was such a simple and beautiful solution.

[@SbNoeZ]

You have solved so many of my issues with this simple video. huge thanks :)

[@Cna18183]

Thank you very much for sharing. This really helped me a lot, I had this problem for a week until I found this video. Well explained compared to other similar videos! 👍

[@harryp1249]

Stated many times below. This is the only solution that actually works when comparing periods.

[@brunamenoncin6587]

Amazing video! Thank you for explaining so clearly, it saved my life

[@gonia24]

Thank you. This video help me a lot with similar problem. I have a question. Is possible compare more than 2 columns?

[@m.tuhinurhasan3385]

Thank you. Very useful information and well explained. Great resource

[@selu3614]

Sick video, literally what i wanted to do. Infinite thanks for your work!

[@arxelyoudom6992]

Thank You very much, You saved one more person!

[@tx955]

Nice sharing. I encountered a problem when using month as the 1st column replacing Category column. The Compasion Sales only shows YTD as one number, not by month.

[@katnilab]

Thanks for the vedio. Can i please check, if you want to add a % change to the table ex: current year vs previous year, how would you go about eliminating the range of non existing perior of the current year, from the past period. Would that not be the true comparison? I.e. If its 2019 March, I would like to compare like for like - 2019 March vs 2016 March. You are currently (i assume in this video) comparing at 11:02min 2019 and 2016 - but 2019 is not yet finished so it is not like for like.

[@michaelcorsibin6108]

What if I want to show the total sales of 2019 and total sales of 2017 seperately as two different visuals and a result table that gives me the difference between the two years. Any video available for this ?

[@EricaDyson]

Great. Will use this idea for sure. Thanks a lot.

[@sebastienschoonjans9727]

Is it possible to have a stock snapshot, with two dates with two cumulated Stock measures. Then take the stock average between period?

[@joeromero7165]

Love this. Thanks for sharing!

[@robemieorpilla8162]

Love this video! Very helpful indeed. :)

[@telmocosta5745]

What about if you want to show data between the 1st date and a 2nd date?? Basically I select 1 of the dates then if i select the other one it doesnt show any data (Like it was in this case, can the problem be because my dates are from the same table (different columns)), I also did a measure to check if 1st Date >= startDate and 2nd date

[@sameerunawane]

can we do this in metric visual?

[@wayneedmondson1065]

Very nice! Thanks for sharing this technique. Thumbs up!!

[@phanatik101]

If we are updating the "Calendar" table in the future, does the "comparison calendar" table updates as well?

[@Agile-Insights]

depends how you create the comparison calendar. if you ref the main calendar in PQ, then yes

[@joedi]

What if I wanted to compare rates by population for a single state in a fact table against rates by the whole for the whole country (not all others). I have already calculated the rate measure. Thanks

[@junedahmed1469]

Hello, my main date table gives me a hierarchy ( year, quarter,month). However after creating the comparison table, the hierarchy switches from main date table to Comparison table. I want year, month ,quarter for comparing. But my main date table loses hierarchy after creating comparison table. Could you please help me out? Will be waiting to hear from you soon. Thanks

[@MasTommy21]

is there anyway to do that without making a comparison table? im trying to not bloat the data

[@MasTommy21]

Hi. Im doing the hierarchy level (Year & month & Date). How do i write the dax for the title? Thxx

[@hoges510]

Vids are the way to go ;)

[@mayurarun]

Great video

[@wmfexcel]

Nice tip! Thanks for sharing.

[@marcfischer6554]

Awesome! Thank you so much! :)

[@james_msuk]

Good guide but the comparison table doesn't work by month, just shows the whole year.

[@RwikKumarDutta]

great video

[@tamarsimonishvili4236]

THANK YOU!!!!!

[@Alan-eb6gp]

very cool, thanks

[@totvabe1]

Very useful! Thanks.

[@sceleton0429]

You saved me!