IFs Query

[Anonymous]

Hello PowerBI Community 😁,

I'm new with PowerBI, query, & Stuffs. & I need help with something.

So i've this kind of logic that i need to apply in my powerBI,

Incomplete means = the status is 'new' or 'in progress' & endDate < from today

i've tried with this,

IF(

'Productivity and Task Organization'[Status] = "In Progress"

&& 'Productivity and Task Organization'[Status] = "New"

&& 'Productivity and Task Organization'[End Date] < TODAY(),

"Incomplete", 'Productivity and Task Organization'[Status]) 

But it doesn't work. the status is still "In Progress" & it should be "In Complete" because the end date is already 24-jul

Any help will be appreciated 🙏

[Fowmy · Accepted solution]

@Anonymous 

Can you try this Measure:

M = 
IF(
    (
        'Productivity and Task Organization'[Status] = "In Progress" || 'Productivity and Task Organization'[Status] = "New"
    )
    &&
    (
    'Productivity and Task Organization'[End Date] < TODAY()
    ),
    "Incomplete",
    'Productivity and Task Organization'[Status]
) 

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

I accept KUDOS 🙂

YouTube, LinkedIn 

[Anonymous]

It's worked, thanks for the help 😁