Power Pivot Month Sorting using Time Table – Part 3
In the previous article, we saw how to create custom sorting order using a separate month table.Now we will see how a new type of table called Time Table can
In the previous article, we saw how to create custom sorting order using a separate month table.Now we will see how a new type of table called Time Table can
Here is the Power Pivot way of customizing sort order for any column. We will continue with the month sorting order example. Read the previous article first. Estimated reading time
If you use text month in a Power Pivot Table, it is sorted in alphabetical order. Here is the solution to the problem. Quick Solution time 2 min Detailed reading
Today everything in IT is driven by hype, fashion, “cool”ness, social media popularity and so on… But real, serious, efficient work still requires full Windows + Office! Estimated reading time
“At first” is the key issue here.Often intranet is the first project undertaken by IT. This is not the best choice. Find out what is the best way to ensure
This is a short post. NO need for a graphic or screenshot. Every time I conduct a session, I poll the audience – “How many of you use OneNote?”. YES>
OneNote is slowly gaining popularity. But I noticed a problem.People like it – they want to use it – but the EXACT steps of starting to use OneNote are not
Excel 2013 Professional edition contains two very powerful add-ins – Power Pivot and Power View. Unfortunately, most users who need these features do not even see these in their ribbon.
This was a query from a customer, but I thought everyone will benefit from this.Step by step instructions shown. This is a 5 minute video. View in full screen at
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
