Forum

Hi Robb, I'm not 100% clear on what you want, but if you want to merge a table to itself, you can do this by selecting the table in both drop downs...

Hi Robb, Please provide a sample Excel file showing what you're trying to do so we can reproduce the issue and better understand and help you. M...

Hi Sarah, Thanks for sharing your file. The problem is caused by the wrong structure of your Ratios data. You have a partially pivoted dataset and ...

Hi Sarah, Have you applied sorting to the PivotTable? Mynda

That's a shame. There must be a function in my code that you don't have. No idea which one though, sorry.

Hi Tracy, Difficult to say without seeing your files. If I were you, I'd copy the M code from your query, then create a new query using Get Files &...

No screenshot attached. What is your locale date format, dd/mm/yyyy or mm/dd/yyyy? Mynda

Hi Tracy, I'm not aware of a way to do this with Power BI, sorry. However, it should be a one time change you need to get them to do, or you connec...

Hi Laura, Great to hear you're making progress. In regards to slicers filtering other pages, please watch session 4.06 at about the 10 minute mark ...

Hi Leanne, The SEQUENCE function is only available in Excel for Microsoft 365. If you're getting the #CALC! error, maybe it's because you don't hav...

Yes, that looks like it returns the correct results.

You could certainly enter the formulas in columns that are currently empty in anticipation of growth in your data. Have the formula return #N/A if the...

I'm not sure this has worked as you're expecting. I think the dates in Sheet1 that start with 12/ are December dates, but in the query in Sheet2 they ...

Nice! Thanks for sharing.

Hi Ton, Are you able to share the query file and source files? Power Pivot's compression works best when there are duplicate values in a column....