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

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

cathoms you are the missing the fundamentals here, reason show items with no data worked because the column was getting aggregated (implicit measures) since there is no aggregation required there is no use of show items with no data 

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

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

    Thanks parry2k. I didn't mention this in my OP but I think I do need the aggregation in order to show the average Days to Intake or Days to Reivew for my value totals, like this: