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.
amitchandak's avatar
amitchandak
Super User
6 years ago

Join both Dates with the same date dimension.  One join will be enabled and another one will be disabled.

Now in calculate use "userelation" to activate the relation you want