Last seen: Apr 20, 2025
Easier to provide a solution if you upload the worksheet instead of picture which cannot be manipulated. I think without actually applying to data th...
See the attached whereby I split the first column in Power Query and then exported the query to the Data Model. This then allowed the creation of two...
crossposted at: and at:
Pictures are of little value as we can not ascertain the format or functionality of the cell values. Suggest you upload a sample file that is represe...
let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"DATA", type text}}), #"Added Cu...
It may be helpful if you attach the file here so that we can test the the query.
Instead of a drop down box from data validation, use a combo box from the Developer Tab. See tutorial
Since you posted in the Power Query sub folder
crossposted: Please read:
crossposted: Please read:
I used Power Query to get the data for Altria from Yahoo Finance. Here is the Mcode for that import. Loaded one year's daily values very quickly. ...
Your attachment is unreadable for me. It has appeared as all WingDings.
Based upon the info provided then: let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Filtered Rows" = Table.SelectRows(Source, ea...
Phil, That is exactly what I came up with. I am guessing that to get them as Serghi has, we need another column filter on. Thanks very much. You...
Phil, I am curious as to how you would do the same as asked with out regard to the column Account and only total based upon the change in Descripti...