Forum Discussion

Dash7's avatar
Dash7
Frequent Visitor
2 years ago
Solved

Calendar table problem (blanks)

I have a table that contains columns: TASKID, created_on, Implemented_on.  As you probably know, column Implemented_on can maintain empty cells. anyway I want to create simple visual, tasks created ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Dash7 

     

    This blank issue is not caused by the calendar table. As column Implemented_on can maintain empty cells, if you add measures/columns related to Implemented_on dates to the chart, the empty date values will be aggregated to the "Blank" column as you showed in the picture. 

     

    As a workaround, you need to filter out those empty date values in measures. For example, 

    Implemented No. = CALCULATE(COUNT('Table'[TaskID]),NOT(ISBLANK('Table'[Implemented_on])),USERELATIONSHIP(_CALENDAR_TABLE[Date],'Table'[Implemented_on]))

    Note that I use USERELATIONSHIP function in this measure because I created the relationship between these two columns as inactive. 

     

    I created a demo pbix with the last calendar table code you offered. You can download it to see the details. 

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!