Excel to DAX

[Anonymous]

Hi,
Need help in converting Excel to Calculated column for below two formulas

1. =IF(AND(P7="C”),TODAY()-M7,"")

2. =IF(AND(Z7="")," No Action Required",IF(AND(Z7<=21),"Outstanding Actions",IF(AND(Z21>21),"Overdue Actions","Check")))

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

Best Regards

Maggie

[v-juanli-msft]

Hi @Anonymous 

P7, Z7,M7,Z21, are columns or cells as below

Best Regards
Maggie

[Anonymous]

All of them refer to columns or table header

[v-juanli-msft]

Hi @Anonymous 

If i understand you correctly, you could create measures or calculated columns below

Measure 1 = IF(MAX('Table'[P7])="C",TODAY()-MAX([M7])," ")

Measure 2 =
IF (
    MAX ( [Z7] ) = BLANK (),
    "No Action Required",
    IF (
        MAX ( [Z7] ) <= 21,
        "Outstanding Action",
        IF ( MAX ( [Z21] ) > 21, "Overdure Action", "Check" )
    )
)


Column 1 = IF('Table'[P7]="C",TODAY()-[M7],BLANK())

Column 2 =
IF (
    [Z7] = BLANK (),
    "No Action Required",
    IF (
        [Z7] <= 21,
        "Outstanding Action",
        IF ( [Z21] > 21, "Overdure Action", "Check" )
    )
)

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.