Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Retain current value of column

Is there a DAX function or some way to retain original value of a calculated column?   Eg: IF I have a column say "Column". Formula for Column is :   Column = IF ( FORMAT ( WEEKDAY ( TODAY () ), ...
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi SNawalKishore1 ,

     

    Thanks for your reply.

    I included Modified date in my column and used following formula to get the desired result:

    CALCULATE(
        COUNTROWS('Table1'),
        FILTER(Table1','Table1'[User]='Table2'User]),
        FILTER(ALLSELECTED('Table1'),'Table1'[IsReviewed]="Yes"),
        FILTER('Table1','Table1'[ModifiedDate] <= TODAY() - WEEKDAY(TODAY() -3))
    )

    Cheers,

    Sumit