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....
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

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?

  • mohammadyousaf's avatar
    mohammadyousaf
    Resolver II
    4 years ago

    Measure.. I have chart with values A & B

    so when I select A

    When I select B

     

    here when A or B not selected

    it shows 1, and i want it to be MIN of Actal Start - Today() because B is still in progress and it should calculate unless there is a completion date. 

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      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