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.

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!!

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

      Hi,

       

      That line creates a single column table with all dates from start to end for each ID.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        I understand now. I do get an error " The number is out of range of a 32 bit integer value Details: 42359.66638"

        Any tips to fix that?