Forum Discussion

torbenani's avatar
torbenani
Frequent Visitor
5 years ago
Solved

Comparing date isue

Hi  hope you're able to help me with this issue. In a table of service request, I want to list requsts, which has been closed (solutiondate) within a given date range. the calendar table is link t...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi torbenani 

    From my test, you just need to build an unrelated Calendar Table, then your measure works well.

    I build a easy sample.

    Calendar Table:

    Calendar = CALENDARAUTO()

    You don't need to build a relationship between two tables.

    I try your measure. 

    Closed in Selcted periond = if(SELECTEDVALUE('Table'[Solution Date]) < MAX('Calendar'[date]) && SELECTEDVALUE('Table'[Solution Date]) > CALCULATE(MIN('Calendar'[Date])) , "Yes", "No")

    Result:

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi torbenani 

From my test, you just need to build an unrelated Calendar Table, then your measure works well.

I build a easy sample.

Calendar Table:

Calendar = CALENDARAUTO()

You don't need to build a relationship between two tables.

I try your measure. 

Closed in Selcted periond = if(SELECTEDVALUE('Table'[Solution Date]) < MAX('Calendar'[date]) && SELECTEDVALUE('Table'[Solution Date]) > CALCULATE(MIN('Calendar'[Date])) , "Yes", "No")

Result:

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.