I use it routinely yes! I mainly use it for transforming large datasets which I guess is the intended purpose but I use it to add additional columns that weren't included in the data extract. I often use conditional column.
Having this little nugget in my pocket will definitely help make things easier! Often times I don't realize I have an error value until I go to put the information into a pivot table.
I use it routinely yes! I mainly use it for transforming large datasets which I guess is the intended purpose but I use it to add additional columns that weren't included in the data extract. I often use conditional column.
Having this little nugget in my pocket will definitely help make things easier! Often times I don't realize I have an error value until I go to put the information into a pivot table.
Conditional columns rock, power query in general rocks. Im so glad you found the article useful :-)