Forum

Hi, I cover lookup charts here and scroll and sort tables here. Mynda

Hi Julie, Try this in cell N2: =MID(INDEX(B1#,SEQUENCE(COUNTA(INDEX(B1#,,1))-1,,2),9),18,6) Mynda

Hi Deidra, I cover Direct Query in lesson 2.04 of the Power BI course. It's just a way of connecting to a dataset other than via Power Query. D...

Hello! For example, when you create a report you often don't use all the columns in your source dataset. Or you might have data for multiple years ...

Hi Deidra, Thanks for clarifying. It sounds like you are using the Power BI service to get data from a Workspace that your IT people have published...

Hi Amit, If you have multiple countries in your dataset, then you should have a country column. In which case you can merge the city or state and c...

Hi Deidra, Its' great to hear you're implementing Power BI. I'm a bit confused as to whether you're wanting to use the Power BI data in Excel o...

No, I mean the empty cells have non-printing characters. The numbers look ok. Load the table to Power Query, make sure all empty cells display as '...

Hi Vijay, Looks like there are some non-printing characters in the cells of the FX table that appear blank. If you select a bunch of empty cells, y...

Hi Kasey, Your spreadsheet should have 3 columns: Plant Type (tomato, beans, corn etc.) Task (sow, plant, harvest) Month (enter proper dates...

Great idea! Thanks for sharing.

Hi David, If I understand correctly, you want a running total. See this tutorial on running totals in Power Pivot. You could also try using the...

Hi Sue, Unfortunately, there's no way to copy the formatting when you use 'show report filter pages'. The macro will be the way to go. I would ...

Hi Brian, Welcome to our forum! You can use the INDEX function to return an array. In your formula it would look like this: =FILTER(FILTER(tb...

Hi James, You can use this formula to put the resource value in the Gantt cells: =IF(MEDIAN(K$17,$C18,$D18)=K$17,$J18,"") You'll need t...