Forum

Hi Holly, It's a bit difficult to picture from your description. In particular this sentence isn't clear "I have a data set with both rows and colu...

Hi Angela, Sounds like you need a 4-5-4 or 4-4-5 calendar. You can create this in Power Query (within Power BI) as explained here. Mynda

Hi Lauren, The short answer is yes and in this case it means that those with Excel 2010 will not be able to interact with the Slicers in your Excel...

Hi Adele, When you import an Excel Power Pivot model into Power BI using the File tab > Import > Excel Workbook Contents menu, Power BI effec...

Hi Angela, I'm so pleased my training has been worth your while. Publishing to the cloud is included in your Pro licence. The catch is that each...

Hi Blanka, You can use Number.Round for this. e.g. =Number.Round([value column], 1,RoundingMode.Up) Or for rounding down: =Number.Round([v...

Hi Declan, You would have to use the INDIRECT function e.g. =INDIRECT("'C:Documents"&FormulaB&"Summary'!P2") , but as INDIRECT is a volatil...

Hi Angela, When you purchase a subscription it's important that all Power BI users who wish to share and collaborate also use the same email domain...

Hi Adele, If these 5 queries all contain Fact type data, which it sounds like they do, then they really should be consolidated into one table befor...

I'll email you the renewal link. Let me know if you don't receive it. Mynda

Hi Celeste, I can't see the last step in your screenshot, but the error is saying that you've tried to convert or use a column as a number data typ...

Sorry, I didn't realise you hadn't even started the Power Query course. I'm glad you figured it out. I'd do the Power Query course first since gett...

Hi Cory, Thanks for providing such a clear example and file. You can do this in Power Query using Merge As New, then use a Right-Outer join so ...

Hi Angela, Are you able to share a screenshot showing your Slicer visual active (select it with the mouse), and the interaction symbols on the prob...

Hi Stephanie, As Anders said, there's nothing more we can do without a sample Excel file. Can you upload something we can look at that contains you...