johnny51981
Active Member
- Joined
- Jun 8, 2015
- Messages
- 409
I'm not a fan of having more than one Change Type step in my queries. I set them at the start and add it within each step moving forward.
Example. For any new Text Columns I create, I will add in the "type text" at the end, as in the following M Code.
Question:
I would like Unbilled WIP by SOW Type to remain as Currency.Type after they are broken into the different Category WIP Columns. Where would I put that in this M Code?
Example. For any new Text Columns I create, I will add in the "type text" at the end, as in the following M Code.
Power Query:
= Table.AddColumn(#"Filtered Rows", "Category WIP", each if [Category] = "Restoration" then "Construction WIP" else [Category] & " WIP", type text)Question:
I would like Unbilled WIP by SOW Type to remain as Currency.Type after they are broken into the different Category WIP Columns. Where would I put that in this M Code?
Power Query:
= Table.Pivot(#"Grouped Rows", List.Distinct(#"Grouped Rows"[#"Category WIP"]), "Category WIP", "Unbilled WIP by Sow Type", List.Sum)
