Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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