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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
alanphamvistra4
Frequent Visitor

Convert Excel Equations into Equivalent DAX Equation to Add Calculated Column to Loaded Data

I am trying to convert an equation I used in excel into a DAX equation to create a calculated column to add to data table that is already loaded into Excel.

 

Excel Equation: 

Status=IF(DATEVALUE(A5)<$D$1,"Expired",IF(DATEVALUE(A5)-30<$D$1,"Expiring","Active"))

 where A5 is Expected Expiration Date and Date is = TODAY()

 

What would be a similar DAX equation?

 

 

2 REPLIES 2
SivaMani
Resident Rockstar
Resident Rockstar

@alanphamvistra4, Create a calculated column in your table using DAX,

 

Status = SWITCH(
    TRUE(),
    'Date'[Expected Expiration Date] < TODAY(),
    "Expired",
    DATEADD('Date'[Expected Expiration Date],-30,DAY) < TODAY(),
    "Expiring",
    "Active"
)

 

Hope this helps!

Anonymous
Not applicable

Hi, Try this.

 

Column Calculated = IF(DATEVALUE([COLUMN WITH A5])<TODAY(),"EXPIRED",IF(DATEADD([COLUMN WITH A5],-30,DAY)<TODAY(),"EXPIRING","ACTIVE")

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors