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, I'm trying to create a custom column for inventory purposes. There are two relevant columns I need to include in the formula:
The data I'm bringing into PQ is already populated with some of this data, but I want the custom column to populate via a check on the existing data. The logic would be something like this:
How can I create a custom column formula to capture this logic? I'm having some difficulty composing it with the M language.
Solved! Go to Solution.
Hi @DDesmond
You already have it
if [Out of Possession] <> null then [Out of Possession]
else if [Product_EUD] = null then false
else true
Hi @DDesmond
You already have it
if [Out of Possession] <> null then [Out of Possession]
else if [Product_EUD] = null then false
else true
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.