Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

If And measure calculated column

Hi Experts

 

need a calculated column measure to do the following if Posting date is blank and Invoicenumber (column) is also blank then 1 ottherwise 0...
The below is not working on second if

ChackFlag = IF(FACT_NEWBI_NewSalesDashboard[SOPostingDate]=BLANK(),1,IF(FACT_NEWBI_NewSalesDashboard[InvoiceNumber]=BLANK(),1,0))
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi Anonymous 

    If you want to create a measure, try this

    ChackFlag_measure =
IF (
    ISBLANK ( MIN(FACT_NEWBI_NewSalesDashboard[SOPostingDate]) )
        && ISBLANK ( MIN(FACT_NEWBI_NewSalesDashboard[InvoiceNumber]) ),
    1,
    0
)

    If you want to create a calculated column, try this

    ChackFlag_column =
IF (
    ISBLANK ( FACT_NEWBI_NewSalesDashboard[SOPostingDate] )
        && ISBLANK ( FACT_NEWBI_NewSalesDashboard[InvoiceNumber] ),
    1,
    0
)

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    4 years ago

    Anonymous try this:

    ChackFlag = IF(FACT_NEWBI_NewSalesDashboard[SOPostingDate]=BLANK() && FACT_NEWBI_NewSalesDashboard[InvoiceNumber]=BLANK(),1,0)

     

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous 

    If you want to create a measure, try this

    ChackFlag_measure =
IF (
    ISBLANK ( MIN(FACT_NEWBI_NewSalesDashboard[SOPostingDate]) )
        && ISBLANK ( MIN(FACT_NEWBI_NewSalesDashboard[InvoiceNumber]) ),
    1,
    0
)

    If you want to create a calculated column, try this

    ChackFlag_column =
IF (
    ISBLANK ( FACT_NEWBI_NewSalesDashboard[SOPostingDate] )
        && ISBLANK ( FACT_NEWBI_NewSalesDashboard[InvoiceNumber] ),
    1,
    0
)

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.