Forum

Hi Ralph, In your example file you want Qty. Hours, but I don't see any column labelled 'Hours'. You have Budget and Hourly Rate. I don't know what...

Hi Victoria, Welcome to our forum! Please upload a sample Excel file, anonymised if required, and showing the before and desired result, so we can ...

Hi Declan, Try: =CALCULATE(TOTALYTD([Sum of Actual],'Calendar'[Date],"3/31"),SAMEPERIODLASTYEAR('Calendar'[Date])) Mynda

Hi Lasse, Welcome to our forum! It's odd that you couldn't use either file. I wonder if it's a regional setting causing the issue with your system....

Hi Scott, No, Slicers can't respond to values typed into text boxes. If you want to filter based on a range, why don't you use the filter buttons o...

Hi Lukasz, No file attached. Be sure to click the 'start upload' button after selecting your file. That said, Power Query is most likely the too...

Hi Gene, It's still not clear if you want to highlight up to the current date or the original end date of the project, and as you didn't provide a ...

The problem is the screenshot doesn't illustrate the structure of the underlying data. What people usually do when they can't share their data is to c...

Hi Shirley, Welcome to our forum! Those functions are only available in Excel 2019 or Microsoft 365. You would need to upgrade to get them. Mynd...

Please provide a sample Excel file with some dummy data/extract of your data that illustrates the problem. Thanks, Mynda

Hi Hitesh, No file attached. Please be sure to click 'start upload' after selecting your file. I think this is a Power Pivot question, not Power...

Hi and welcome to our forum! Can you please provide a sample file as I'm struggling to visualise the issue. You can just create a small set of dumm...

Hi Adam, Welcome to our forum. You can write your IF formula like so: =IF(A1>0,A1*1.25,A1) Assuming you want to keep the value in A1 or...

Hi James, The formulas starting in cell B71 are missing absolute referencing and they're not the same. i.e. the ROW formula in the IF formula's val...

Hi Gene, Welcome to our forum! You haven't said which cells you want the format applied to. e.g. the whole row, the date cells relating to the proj...