Forum

Hi RaiSta, You could try if Text.Length(<txt>) > 0 then Text.Start(<txt>, MAX(0,Text.Length(<txt>)-1)) else null Regards...

Hi Nivian, Nothing is attached - you need to click on the Start Upload button to upload the file(s). What version of Office are you using? Ar...

Hi Keith, Looks like the account being used to access the file does not have the required permissions to do so. If you've just moved everything ...

Hi, Try this Sub SortCols() ActiveSheet.ListObjects("Table1").Sort.SortFields.Clear Range("Table1").Sort Key1:=Range("Table1[[#All],[Col3...

No worries Chloe.

Hi Johnson, In the query I don't see any step that tries to Fill Down. I also don't see where you tried to replace ' as blank. And if I search th...

Hi Chloe, There's no file attached, you need to click on Start Upload after selecting the file. But, I think what you are trying to do can be do...

Hi Chloe, Can you please provide some sample data and explain how you know some links are wrong and when/why an error will occur. Without these ...

Hi Richard, I'm not sure if you are appending or merging data, it'll depend on the structure of our tables. But you could try something like this ...

Hi Stuart, You can write a measure like this CF Expired Cert = IF(MIN('Data'[Expiry Date]) < TODAY(), "RGB(240,0,0)") Then set the...

Hi Stuart, Can you supply your PBIX file? regards Phil

Hi Papaku, Try this =IF(COUNT(A2:G2)>0,COUNT(A2:G2) & " trainings completed", "No training completed to date") regards Phil

Hi Femco, Please provide some data to work with. If you have it in PQ then you can provide it in a workbook for me, rather than me having to type ...

Hi Femco, Please provide some sample data so we don't have to recreate it. Please provide an example (image, table, workbook) of what you want y...

Hi Salim, Please check these links What is Data Streamer? (microsoft.com) Enable Data Streamer in Excel - Excel Data Streamer | Microsoft Doc...