Forum Discussion

jalaomar's avatar
jalaomar
Helper IV
4 years ago

Datediff return blank value

Dear all,   could some help me how to use Datediff function so that in my table I can view all projects and if ITG4 actual date is blank then return a blank row for that measure? please   as you ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

jalaomar Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

jalaomar's avatar
jalaomar
Helper IV
4 years ago

Hi Greg_Deckler ,

 

Thanks for your feedback

 

so I have these two columns ITG4 baseline & ITG4 actual dates and the following measure is calculating the date difference between these two dates.

 

PVoT Days = DATEDIFF('KPI'[ITG4 Baseline Data],'KPI'[ITG4 Actual Date],DAY)
 
It is working OK, but when I add the measure to the table visual, I only see the Projects that have values in the ITG4 baseline & ITG4 actual. see pic below.
what I want instead is to view all the Projects in the tables visual even for those cases where the ITG4 actual is BLANK. Is there a way to visualize all these projects when I add the measure to the table visual ?
 
  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    4 years ago

    jalaomar Try:

    PVoT Days = 
  VAR __Diff = DATEDIFF('KPI'[ITG4 Baseline Data],'KPI'[ITG4 Actual Date],DAY)
RETURN
  __Diff + 0
    • jalaomar's avatar
      jalaomar
      Helper IV
      4 years ago

      Hi Greg

       

      I tried out the measure and it didn't exactly give me the results I was looking for 

       

      so below pic is all the data in the table visual and the second visual is when I include the measure to the table visual