Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Calculate if value is between dates

Hello all,    I already tried making this topic last week, but it seems to have vanished.  I'm new to power BI and dax and could use some assistance.    I have a table with cases something like ...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi Anonymous,

     

    You may refer to my solution here.

     

    Hope this helps.

miltenburger's avatar
miltenburger
Helper V
8 years ago

Hi Anonymous

 

First thing to do is, have a time slicer to select the date you want to see the information from. 

Next thing you do, create meausre:

active = CALCULTATE(COUNTROWS(tablename), closedata = "null")

Then select your date you want to see

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    hi miltenburger,

     

    Thank you for your answer. Unfortunatly this seems to return an error, and with some changes it only seem to retrieve cases that are currently open (closedate null). I'm looking for all the active cases of a day in history (the slicer was a good idea!). 

     

    so it should only return cases for which:

    create date <= [date selected] < end date  AND create date <= [date selected with end date = null.

     

    Any further ideas? Cause it is greatly appriciated :)!