Forum

Hi Alex, Welcome to our forum! I haven't had a lot of experience working in files created in another language, but from time to time I get sent ...

Not to worry. On the positive side, you won't ever forget how to fix this problem should you ever come across it again 🙂

Hi PB, In the 'Data' folder you downloaded containing the practice files there is a text file at the top called '_READ_ME_FIRST.txt'. In this file ...

Hi Tim, If you add a calculated column to calculate the variance in the actuals table then you'd need a relationship between the tables to support ...

Hi Bill, You can remove the date hierarchy by clicking on the drop down for the date field in the Axis labels list. If that doesn't work, please...

Hi PB, The date fields in your Missions table are text. You need to fix the data types in Power Query to dates. Note: I didn't check the other tabl...

Hi Abid, I can't replicate the error and the file you shared doesn't contain your query, so I can't see what the error message is. I wonder if i...

Hi Abid, The file didn't get attached. You need to click the 'start upload' button after selecting your file. That said, try converting the text to...

Hi Lee, Great to hear you're enjoying the Decision Making course. Isaac doesn't do a course on Monte Carlo Simulation specifically, but his Anal...

Thanks, PB. Where are the images of the PivotTable and field list so I can see what fields you've used in your PivotTable and what tables they come fr...

Hi PB, Nothing uploaded. You need to click 'start upload' after selecting your file and then wait for the green notification under the attachment's...

Hi Robert, The only way to hide the items from the Slicers is to remove them from your source data. As for sorting the Slicer items based on the Pi...

Hi Pieter, You can use the technique described here for the Complex Table to reference the row above/below in Power Query. In your attached file...

Hi Simon, Power Query in Excel doesn't support the Web.BrowserContents function yet. You can only scrape by example in Power BI at the moment. Y...

Oops, sorry! I forgot to insert the link. I've edited the post above and the link is there now.