Forum Discussion
SCHOOL ASSIGNMENT: Multiple conditions in an conditional column
Dear PowerBI gurus, For our school assignment we've received a data set with clear requirements, we need to clean this and import this to a MS Database later. At the moment we've covered most par...
We've managed to solve this challenge with the following formula:
= Table.AddColumn(#"Renamed ALG_VerkoopPrijsExcl new", "Custom", each if Text.Contains([ALG_Omschrijving], "serie") and [VOORRAAD_Aantal] > 10 then 10 else [VOORRAAD_Aantal])
We've also tried this formula, unfortunately it also didn't work:
=Table.AddColumn(#"Renamed ALG_VerkoopPrijsExcl new", each if text.Contains(ALG_Omschrijving,"serie") and VOORRAAD_Aantal > 10 then 10 else VOORRAAD_Aantal)