One of the most common comments we get here is “how does xxx formula works?” Even though there is vast documentation on excel formulas including the built-in help in MS Office, often it is difficult for us to learn a formula quickly and use it in a snap. So to help new users of excel learn the most frequent formulas I have built an excel formula helper page.
The page currently lists about 50 most commonly used excel formulas along with 1 index card for each to explain,
- what the formula does
- what is its syntax
- 2 examples to understand how it works
see an example:
The good thing about these index cards is, they use simple day to day English to explain the formulas, so I am guessing they are a great way for new users to learn and use the formulas.
I have tried to keep the page simple so that anyone can come and learn a few formulas quickly. Play around with it and let me know if this is useful (of if something is funny / broken)
Here is the link: excel formula helper – 50 day to day formulas explained in plain English
If you like it, please support me by adding it to delicious or stumble or sharing it with a friend 🙂
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.