Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Can't see future dates in visual

I've got a table with some dates in the future. Somehow my visual won't show these dates, when using a custom date table.

 

The measure used is:

Expected Amount = CALCULATE(SUM('Lead'[Amount]), USERELATIONSHIP('Lead'[ExpectedDate], 'Calendar'[Date]))
 
The first visual is using the ExpectedDates from the lead table, while the second is using my calendar table.
The relationship between lead and calendar is inactive, so that's why I need to use USERELATIONSHIP.
My calendar table contains dates from 1-1-2011 to 31-12-2021 (DD-MM-YYY)
 
Can someone help me display these future dates using my calendar table?
Need Help

3 Replies

  • CNENFRNL's avatar
    CNENFRNL
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous , generally speaking, when a measure returns BLANK(), viz doesn't show it by default; a common trick to convert BLANK() to 0 is like this,

    Expected Amount = CALCULATE(SUM('Lead'[Amount]), USERELATIONSHIP('Lead'[ExpectedDate], 'Calendar'[Date])) + 0
  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous 

    Does this issue still occur now? I used some sample data as shown below to test your measure and the visual is displayed well with the future data.

    Sample data for Table‘Lead’and the relationships between tables:

    Calendar table formula: Calendar = CALENDAR(DATE(2017,1,1),DATE(2022,12,31))

    And the result is displayed totally with the future data:

    So can you check if there is any other filters that may influence the filter context in your model?

     

    Best Regards,

    Community Support Team _ Jing Zhang

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