Since Financial Modeling School 2nd batch is opening next week, things have been a bit crazy at chandoo.org HQ.
So we will start the week with an ultra quick tip. It always surprises me that not many people know this. So here it goes,
Lets say you have some data in 2 columns and you want to compare row by row to spot the differences. Of course you can write a formula or apply conditional formatting. But there is a quick and dirty solution that works just as fine.
- Select both columns with data
- Press F5 and select special (alternatively, from home ribbon, click on Find & Select and then choose Goto Special)
- Now, click on “row differences” and press OK.
- Excel instantly highlights all the cells in 2nd column that do not match with first column.
- Just change their color or something so you know where to focus your attention.
- Done!
See this demo to follow the steps:
Want more? Here is more:
- A ridiculously fast way to highlight mismatches in data using Conditional formatting
- Learn more quick tips and become an Excel rock-star.
2 Responses to “Top 10 Power BI Interview Questions & Answers”
Hello...
In Power BI I have data that includes months by name only (e.g. May, April, December...)
I need to build charts etc. but i need the months to go chronologically... not alphabetically... I cannot seem to find the fix to this.... once again, my data does NOT have an actual date attached to it (like 02/01/2023)....only month names... can i use a helper table wher i id the month names as numbers 1 thru 12? and if so, how do i manage this to work for me ?
Thank you.
~Keith
You need to setup an extra table to map each month name to a running number. A simple 12 row table like
Jan 1
Feb 2
Mar 3
..
Dec 12
Then create a relationship between this month table and your month column
Now, go to "table view" in Power BI and set the sort by column to month number for the month name column on this new table.
Finally, use the new table's month name whenever you need to refer to the month name in the visuals.
They will be chronologically arranged.