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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi Anonymous,

 

You may refer to my solution here.

 

Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Could you maybe explain how it works? Because i have trouble understanding the solution. 

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      8 years ago

      Hi,

       

      Have you tested the result? Does the solution work?  In the Query Editor, i have basically created a single column of dates from your start and end date columns.  So the query loaded to the Data Model has only 2 columns - ID and Date.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi Ashish, 

         

        It seems to do what i want, but i cant test it yet in my enviroment. Can you explain "added custom 1" ({ Number.From([Createdate])..Number.From([Custom]) }) so that i can try to implement it in my enviroment? 

         

        Thank you in advance!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Works perfectly now. My bad for testing it the wrong way 

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      8 years ago

      Good to hear.