Forum Discussion

mohammadyousaf's avatar
mohammadyousaf
Resolver II
4 years ago
Solved

Combining IF Statements

Hi, can someone please help to combine these two statements. 

 

Firs Statement:

 

IF(ISBLANK([Date.Actual.Start]),BLANK(),}
IF(ISBLANK([Date.Actual.Completion]),BLANK(),
(DATEDIFF([Date.Actual.Start],[Date.Actual.Completion],DAY)))) 

 

2nd Statment: 

 

IF( NOT( ISBLANK( [Date.Actual.Start] ) ),

IF(ISBLANK([Date.Actual.Completion]),

DATEDIFF([Date.Actual.Start], [If.Today],DAY)))

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi mohammadyousaf ,

    I created a sample pbix file(see attachment), please check whether that is what you want. You can create a measure as below to get the Days.Calculations:

    Days.Calculations = 
VAR _tab =
    ADDCOLUMNS (
        'Table',
        "@datediff",
            IF (
                ISBLANK ( [Actual Start] ),
                BLANK (),
                DATEDIFF (
                    [Actual Start],
                    IF ( ISBLANK ( [Actual Completion] ), TODAY () ),
                    DAY
                ) + 1
            )
    )
RETURN
    IF (
        ISFILTERED ( 'Table'[Task] ),
        SUMX ( _tab, [@datediff] ),
        MINX ( FILTER ( _tab, NOT ( ISBLANK ( [Actual Completion] ) ) ), [@datediff] )
    )

    Best Regards

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    mohammadyousaf , Try like

     

    IF(ISBLANK([Date.Actual.Start]),BLANK(),
    IF(ISBLANK([Date.Actual.Completion]),DATEDIFF([Date.Actual.Start], [If.Today],DAY),
    (DATEDIFF([Date.Actual.Start],[Date.Actual.Completion],DAY))))

    • mohammadyousaf's avatar
      mohammadyousaf
      Resolver II
      4 years ago

      Thank you, I tried this as well but can not get my desired out put. 

       

      I have multiple rows as below:

       

      TaskActual StartActual Completion
      A30-Sep-2021 30-Sep-2021
      B6-Oct-2021 
         
         

       

      So when I select A, it shows me 1 day as added +1 in the above statement 

      When I select B, it shows me 7 days

       

      But when none is selected, it doesnt calculate Actual - Today.  It just calculate 1 form A. What I am trying to achieve DATEDIFF from 30 Sep to Today. 

      • amitchandak's avatar
        amitchandak
        Super User
        4 years ago

        mohammadyousaf , selected value, means you are looking for a measure? or for a column 

         

        Can you share sample data and sample output in table format?