Need Help on DAX

[ssvr]

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]],""))

[v-frfei-msft · Accepted solution]

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

[v-frfei-msft · Accepted solution]

Hi @ssvr,

I create two measures as below.

Count of project = COUNT(Table1[ProjectNumber])

Measure 2 = SUMX(ALLEXCEPT(Table1,Table1[Resouceinitials]),[Count of project])

For more details, please check the pbix as attached.

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

Regards,

Frank

[v-frfei-msft · Accepted solution]

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]

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]

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

[ssvr]

I need the Sum of Project Count By ResourceInitials wise ( DAX for Measure not Column) because i work on Cubes

[v-frfei-msft · Accepted solution]

Hi @ssvr,

I create two measures as below.

Count of project = COUNT(Table1[ProjectNumber])

Measure 2 = SUMX(ALLEXCEPT(Table1,Table1[Resouceinitials]),[Count of project])

For more details, please check the pbix as attached.

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

Regards,

Frank

[ssvr]

I got this error 

[v-frfei-msft · Accepted solution]

Hi @ssvr，

Try to update the formula to this one.

Count of project = COUNTA(Table1[ProjectNumber])

Regards,

Frank

[v-frfei-msft]

Hi @ssvr,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,

Frank