Forum Discussion

ssvr's avatar
ssvr
Icon for Helper III rankHelper III
8 years ago
Solved

Need Help on DAX

Hi All,

 

I want to migrate a project from Excel - Power BI.

 

I need to write a DAX based on Excel formul. Please help me out

 

Formula is in A9 Cell

 

=IF([@[Case No]]=A10,"",+IF(OR([@Status]="Board Review",[@Status]="Approved",[@Status]="Rejected",[@Status]="In Pilot"),[@[Received Date]],""))

Need Help

8 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi ssvr,

     

    I made an sample for your reference. Here I created a calculated column using the formula.

     

    Column =
IF (
    [Case No] = "A10",
    "",
    IF (
        [Status] = "Board Review"
            || [Status] = "Approved"
            || [Status] = "Rejected"
            || [Status] = "In Pilot",
        "" & Table1[Received Date],
        ""
    )
)

     

    For more details, please check the pbix as attached.

     

    https://www.dropbox.com/s/5bpc08p47rswabx/Need%20Help%20on%20DAX.pbix?dl=0

     

    Regards,

    Frank

     

    • ssvr's avatar
      ssvr
      Icon for Helper III rankHelper III
      8 years ago

      Hi v-frfei-msft ,

       

      Thanks for your reply on DAX

       

      I need one more help from you

       

      Required a DAX of Sum of ProjectNumber Count

       

      CNDOL --- 2

       

      • v-frfei-msft's avatar
        v-frfei-msft
        Icon for Community Support rankCommunity Support
        8 years ago

        Hi ssvr,

         

        Sample for your reference.

         

        Measure = CALCULATE(COUNT(Table1[ProjectNumber]),ALLEXCEPT(Table1,Table1[Resouceinitials]))

         

         

        For more details, please check the pbix as attached. If it doesn't meet your requirement, kindly share your sample data and excepted result to me.

         

        https://www.dropbox.com/s/4t5pkbq5cgfdici/DAX.pbix?dl=0

         

        Regards,

        Frank