Forum

Hi Bax, Please see this tutorial on how to sort by columns in Power BI. Mynda

Hi Lee, Thanks for clarifying. I haven't used any RC references in my formulas (never do), hence my question. I thought you must have been referrin...

Hi Peter, Excel Online cannot refresh queries yet. Your best option at the moment is to write some VBA that opens the file periodically and trigger...

Hi Tania, In the file you shared cell P6 is empty, and the first logical test of the formula is to test if P6>0. In your file P6 is not greater ...

Hi Jason, I see that you have 22 items + some blanks that can be selected in the Slicer. That's 23 OR arguments to manually enter in a SUMPRODUCT fo...

Glad it helped, Lee. Not sure what you're referring to with the RC values...as opposed to what? The Days on Site data is not formatted in a Table, so ...

Hi Tyrone, Welcome to our forum! I see no reason to have the relationship between the PreferredNames and PriorityGroup tables inactive. If you m...

Hi Jason, There's no file attached. You have to click the Start Upload button after selecting your file, then wait for the grey check mark beside t...

I would do the vlookup in Power Query using Merge.

Power Query only shows you a preview of the first 1000 rows of the data. It does this so that it can be responsive when working in the query editor. I...

Great to hear, Simon!

Hi Berat, Welcome to our forum! I think the problem you're having is caused by precision. The numeric equivalent of 8:00 is 0.3333333333' and fo...

Hi Simon, Great to hear you're making progress with the courses! In lesson 6.11 of the Power Query course I cover error trapping using try/other...

Hi Bax, The data model can't access custom lists, therefore you add a sort order to the data model and set the 'sort by' column in there. Mynda

Hi Lee, You can add another criteria to the AND formula for the green conditional format that checks the date and name against the days on site lis...