Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Excel to DAX

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

 

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    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

4 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi Anonymous 

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

    Best Regards
    Maggie

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      All of them refer to columns or table header

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        6 years ago

        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.
  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    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