Assistance with a custom query to create a new column

[zan3gerous]

Thanks for checking out my post! I really appreciate any help offered. 

Im trying to make a new column in my query that is based off of two other columns, "CISA KEV Status", which has two values of either "CISA KEV" or "Not CISA KEV" & another column called "Days to mitigate" which has values in whole numbers, ranging from 0-30.

I want this new column to show only the days to mitigate for values which are "CISA KEV", and for "Not CISA KEV" to be excluded, or zeroed.

thank you in advance!

[divyed · Accepted solution]

Hello @zan3gerous ,

You can create a column using below dax

New_Column =

IF(

    'CISA'[CISA_Status] = "CISA KEV",

    CISA[Days_to_Mitigate],

    0

)

If you need filtered table, use 

Only_CISA_KEV =

FILTER(CISA,CISA[CISA_Status] ="CISA KEV")

If you need different output, attached a sample please.

I hope I answered the query. If yes, mark this as solution. Appreciate Kudos always 🙂

Cheers