Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
DDesmond
New Member

Create customer column based on boolean values & dates of other columns

Hi, I'm trying to create a custom column for inventory purposes. There are two relevant columns I need to include in the formula:

  • Product EUD (End Use Date) - indicates the date that a product's available resources (e.g. amount of liquid in a bottle) depleted
  • Out of Possession - (boolean) indicates that the product is no longer available for use (e.g. if it is depleted)

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:

  • If Out_of_Possession is not null
    • use existing value
  • Else
    • if Product_EUD is null
      • FALSE
    • else
      • TRUE

How can I create a custom column formula to capture this logic? I'm having some difficulty composing it with the M language.

1 ACCEPTED SOLUTION
Vera_33
Resident Rockstar
Resident Rockstar

Hi @DDesmond 

 

You already have it

Vera_33_0-1662878362613.png

if [Out of Possession] <> null then [Out of Possession] 
else if [Product_EUD] = null then false 
else true

 

View solution in original post

1 REPLY 1
Vera_33
Resident Rockstar
Resident Rockstar

Hi @DDesmond 

 

You already have it

Vera_33_0-1662878362613.png

if [Out of Possession] <> null then [Out of Possession] 
else if [Product_EUD] = null then false 
else true

 

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.