Forum

Hi Edward, There's no built in way to do this. You'd have to reconstruct the formula in a text string e.g. =B20&"/"&D5 Which would re...

Hi Matt, It depends on your file structure. Please upload a sample file that illustrates the issue and your desired result. Mynda

Hi Chuck, Welcome to our forum! Try this formula: =AND($AA2<>"",$AA2<TODAY()-14) Mynda

Hi Ivon, Welcome to our forum. If you bring the vertical axis back you'll see that it has a minimum of 133629.8333333333 and maximum of 133629.8...

Hi Mark, Power Automate would be the solution. There is a free Power Automate Desktop tool you can use, but the PC would need to be running for it ...

Hi Mark, Neither of these screenshots have any data because you don't have any fields in your values area. It may appear that you have data in the ...

Hi Sid, You're on the right track. Although, just because a table has many columns doesn't mean it's always a fact table. Facts are your transactio...

Hi Jim, I think that's the wrong attachment! Anyhow, Combine & Transform triggers the combining of the files in the folder into one query an...

Hi Jason, On the page where you can download the project management dashboard, there is an option to download the non-365 version which contains th...

Glad you go there in the end, Sid. Tenacity will get you a long way

It's difficult to picture what you want without an example, file, but you can enter the FORECAST functions manually on a single sheet. You don't have ...

Hi Angel, Welcome to the forum! Please see the lessons in session 10 on using the Time Intelligence functions. If you get stuck, please come bac...

Thanks for sharing your file, Irfan. You need to put group boxes around the two sets of radio buttons. I tested it and that resolved the issue. If you...

Hi Sid, The formula isn't written correctly. If your criteria are AND, you must separate them with && e.g. =CALCULATE(COUNTROWS(Opportun...

Hi Justin, Instead of using the value filter for top 3 in the PivotTable, you can create a regular chart from the PivotTable that only references t...