Forum

Hi Tyrone, Ok, I see what the issue is now. I wasn't following earlier, despite your detailed documentation! You need a measure that activates t...

Hi Tania, Try this: =IF(AND(C6="Datasheet",P6=""),L6,IF(P6<>"",IF(OR(C6="Drawing",C6="Document"),CONCAT(A6,"_","r",Q6,R6),""),"")) M...

Looks like this question isn't about combining datasets as the sample file already has the dataset combined. Rather, it's about extracting data into a...

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...