Forum

Nothing attached, make sure you press the Start Upload button after you select files.

Hi Ravitej, Where is your formula?

In Power Query/Power Pivot, there is no row context, calculations are made on entire columns. Therefore, @ cannot be used as you do in excel tables...

Unfortunately, you can't reference other columns in Table.TransformColumns

Hi Julian, The worksheet name seems to come from range B16 of the ACTIVE SHEET. Make sure the correct sheet is ACTIVE before running the code an...

Hi Shawn, You cannot use dynamic team name to filter the CALCULATE function: CALCULATE ( DISTINCTCOUNT ( tblVelocity[Team] ), tblVelocity[Team]=...

Hi Mike, When you have the list of items in that folder, the first column is Content, with data in Binary format. If you right click any cell from ...

Unfortunately, I don't think it's possible. To show a task as open in months 1 and 2 and closed from month 3 onward, you need to have a status colu...

Hi, You can create a table with all your links, import this table in power query, then add a new column with this formula: =WebContents([URL Col...

Maybe this topic will help, you can check if column 1 is empty and remove it:

There is another way to go: Assuming that your Reorder step has the only intention to bring the Custom column at the beginning of the table, you ca...

Here is your query modified: let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Filtered Rows" = Table.SelectRows(Source, each ([Col...

Hi Tanya, The navigation step is just selecting a sheet, it does nothing to the sheet content, so I guess it's something else. If you can anonym...

Hi Wim, Please clarify what changes you need to do, I'm not aware of any transformation that needs transposing twice. Changing the order of the col...

It does not matter, Power BI has the same tools you have in excel: Power Query and Power Pivot