Forum Discussion

cathoms's avatar
cathoms
Icon for Responsive Resident rankResponsive Resident
4 years ago
Solved

Return blank value on DATEDIFF calculated column

HI. I have a few date columns in my fact table - request submission date, intake date, and review date. Using  DATEDIFF I am calculating days to intake and days to review. When a request lacks an int...
Need Help
  • parry2k's avatar
    parry2k
    4 years ago

    cathoms when you are using this calculated column in the visual, can you make sure it is not getting aggregated. Maybe the aggregation is changed to sum and for that reason the column with the blank value is not showing up.

  • Anonymous's avatar
    Anonymous
    4 years ago

    cathoms , I have found an even easier way to achieve what you want, with no change to your existing measure. In the table visual, in the Values section, right-click on the Request field and select "Show Items With No Data". When you do that, the row for Request 83 will appear.

    More information here

    Show items with no data in Power BI - Power BI | Microsoft Docs

     

cathoms's avatar
cathoms
Icon for Responsive Resident rankResponsive Resident
4 years ago

Thanks to both parry2k and Anonymous !

Days to Intake was aggregating so checking "don't summarize" worked. I also tested the "show items with no data" and that worked as well.