Last seen: Aug 22, 2025
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...
Hi John, I don't see why that wouldn't refresh on another PC. When you say it doesn't work for others, how so? What is MyDataSet? Perhaps th...
Hi Kirsty, Try putting Table.Buffer inside Table.Sort e.g. Table.Sort( Table.Buffer(#"Extracted Day Name1"), .... ) regards Phil
Hi Patrick, You can simplify your code to this =VAR ThisDeptID = MAX(dataPnLDetail[DepartmentOrder]) RETURN if(ThisDeptID <=4,ThisDeptID) ...
Hi Barry, The Listbox has a setting that controls the number of columns it contains. You had it set to 1 column, it just needs to be set to 4. ...
Hi Erik, I'm having trouble picturing things without seeing the data. Can you please attach some sample files/data and an example of the final res...
Hi, You need to explain and show through examples, what transforms you wish to perform. The file you supplied has no queries so I am none the wise...
Hi, You could modify the Transform Sample File query (it's one of the Helper Queries created automatically in PQ) so that it removes the first row ...
Hi Chad, You can do this with a combination of data validation, tables (for lookup) and this formula =XLOOKUP(D4,ZoningDistricts[Zoning District...