Last seen: May 28, 2025
In the column containing the Store Name, click on the Sort drop down. Select Text filer. Select Begins with No Frill and select the Or function in t...
Right click on the value in your PT and select Format. Change the format from General to Number.
Here is the revised code let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Transposed Table" = Table.Transpose(Source), #"Filled ...
let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Transposed Table" = Table.Transpose(Source), #"Filled Down" = Table.FillDown(#"Trans...
Look at this link to help you with your VBA coding.
let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"Future Month ", type any}, {"M...
An alternative is to unpivot your data with Power Query let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Ta...
let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type1" = Table.TransformColumnTypes(Source,{{"Salaries & Wages", type te...
crossposted:
Will there ever be more than three columns with numbers between 1 and 4?
Is this the result you would be looking for in the attached. If so, then this Power Query Mcode should be sufficient. let Source = Excel.CurrentWo...
Have you added the original data to the Data Model. This will increase the size of the file.
Would be extremely helpful if you uploaded a sample file of 10-15 records for us to work with.
Another means is to create a column that is the month number. Then Group By the Month for a Max Date Duplicate that query and remove the last step ...