Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Open OR Close date in one visualization

Hi all -    I work at a Bank, we pull in our depositor data daily through a direct query. At any given time, we only have one 'production date' worth of data, which is a snapshot in time of our acc...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    Create measures

    o = DATEDIFF(MAX('Table'[open Date]),TODAY(),DAY)

c = DATEDIFF(MAX('Table'[Close Date]),TODAY(),DAY)

Measure 3 = IF([o]<>BLANK()&&[o]<=30,1,IF([c]<>BLANK()&&[c]<=30,1,0))

     

    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.
johnmelbourne's avatar
johnmelbourne
Helper V
6 years ago
Or try

= CALCULATETABLE( VALUES(Accounts[ACCOUNT NBR]), OR( FILTER1, FILTER2) )