Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.