Forum Discussion
Add rows based on condition
Hi everyone, I am looking for a solution to add new rows to my dataset. For each Month of each value of [Country Name], I need to ensure that there is a row where [Business] = "Mining". If it does ...
Hi Anonymous
In Edit queries, i create a date table as below
enter dates in box "startdate" and "enddate", then "Invoke", we can get a new table, renamed it as "date",
Then in your table, if you only have three columns, group data as below,
Then add a custom column and expand
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
In Edit queries, i create a date table as below
enter dates in box "startdate" and "enddate", then "Invoke", we can get a new table, renamed it as "date",
Then in your table, if you only have three columns, group data as below,
Then add a custom column and expand
Best Regards
Maggie
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-juanli-msft thank you Juan li, there are much power query techniques on it and I have learned a lot. Very sorry for the late reaction.