Forum

Hi Cedric, Power Query can certainly give you a list of the last value for each part number, but it's not clear from your question as to whether yo...

Hi Shyna, Welcome to our forum! You can create the equivalent stacked bar chart in Excel. There is no setting for a constant line, but you can a...

Hi Gabriele, Welcome to our forum! The reason your other formulas aren't working anymore is because your formula is returning 2 columns of data,...

Hi Usman, No file attached so it's difficult to understand the issue. I suspect the source data you're using is preventing exposure of the email ad...

Hi Edward, Use the SUMX function to iterate over the rows in the underlying table based on the filters. Mynda

Hi Edward, No, box plot charts aren't available for PivotTables. You'd have to create a regular chart from the PivotTable data. Mynda

Sounds like the Excel file might have been generated by an external system and it hasn't been created in a proper Excel workbook format that Power Que...

I would start in a new Excel file. There's probably some links still lurking around.

Hi Kent, Have you tried copying the M code that Power BI creates into an Excel query? I wonder if the version of Excel that you have doesn't sup...

Hi Paul, The technique described in sessions 7.03 and 7.04 are to be used when you save your files to a local PC or server. The path in the screens...

Hi Robert, Thanks for sharing your file. I also get the resources error. I also get stuck in a sign in loop. The formula in column C of the Ledger ...

Hi Tim, You're right, your forecast table is sounding more like a fact table than a dimension table. That said, as long as it contains all the cust...

Hi Kent, The error message implies that the account you're logged into Excel with doesn't have permission to that SharePoint file/folder. The accou...

Hi Robert, No, I haven't run into that problem. If you'd like to raise a new topic in the forum and share your file I can test it on my PC to see i...

Hi Sid, Did you try this: =SUMX ( VALUES ( Table2[Program Name] ), CALCULATE ( DISTINCTCOUNT ( Table2[Supplier] ), Table2[Status]=TRUE ) ) ...