Last seen: Jun 19, 2026
Hi Kaspars, Thanks for clarifying. Your first example, "Minutes past target confirmation time of 14:10" has 2:38 PM as the earliest confirmation ti...
Hi Kaspars, Do you have Microsoft 365/Office 365? I need to know what version of Excel you have so I know what functions you have available. Als...
Hi Corentin, Welcome to our forum! Unfortunately, Power BI is not designed to generate P&L statements, which means this task is not simple. You...
Hi Stefano, I'm trying to advise you on the correct way to assign these attributes to your data. A nested 'if' is the most inefficient way to both ...
Hi Stefano, This should be done with merge in Power Query. i.e. set up a table that has your mapping of years and risk codes to tickets, then use m...
Hi Danielle, It's great to see you're using the new XLOOKUP function. XLOOKUP has it's own error handling built in, so you don't need to use IFERRO...
Hi Maria, Thanks for the file. Create a matrix table with RangeName and ProductKey in the Rows and No of Total Products in the Values. Then you can...
Hi Danielle, Please upload the file again. Be sure to click the 'Start Upload' button after selecting your file. Mynda
Hi Maarten, You can get their capacity, but if you want AbsenceType and HourType in the same PivotTable then you'll have the Capacity column repeat...
Hi Kaspars, Welcome to our forum! Please try uploading your file again. You need to click the 'Start Upload' button after selecting your file. T...
Hi Maarten, It sounds like you shouldn't be using the hierarchy. Instead, just choose the fields from the calendar table and put them where you wan...
Hi William, I'm not familiar with the Power BI report server, however the way Power BI works is you use Power Query to specify the data you want br...
Hi Sam, Please upload a sample Excel file. Thanks, Mynda
Hi William, Usually creating a 'view' of the data you want to get with Power Query and then connecting to that view is the most efficient way to ge...
Hi Louise, So, if there are two or more cells with a p or q or pq then you want row 28 highlighted green you can use COUNTA to count the number of ...