Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi ALl,
I am not getting the results from the Text.Contains to work at all. I am trying to use it as part of the List.AllTrue string. Does it work or any suggestions?
if List.AllTrue(
{[Delay Catergory]="Planned Down"}) then "7"
else if List.AllTrue(
{[Delay Catergory]="Planned Down",
Text.Contains([Description], "Plant",Comparer.OrdinalIgnoreCase)=true
}) then "71"
else if
This is just giving me a the eresult of 7, never the 71.
Thanks in advance.
Cheers
Brad
Solved! Go to Solution.
if List.AllTrue({[Delay Catergory]="Planned Down",
Text.Contains([Description], "Plant",Comparer.OrdinalIgnoreCase)
}) then "71"
else if List.AllTrue({[Delay Catergory]="Planned Down"}
) then "7"
if List.AllTrue({[Delay Catergory]="Planned Down",
Text.Contains([Description], "Plant",Comparer.OrdinalIgnoreCase)
}) then "71"
else if List.AllTrue({[Delay Catergory]="Planned Down"}
) then "7"
Thanks. I have restrucutred so I am not looking for the same Text.Contains under different delay catergories.
It works just not quite fully as easily informative, have to have a lot more else if
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!