Combining IF Statements

[mohammadyousaf]

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

[amitchandak]

@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]

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

I have multiple rows as below:

Task	Actual Start	Actual Completion
A	30-Sep-2021	30-Sep-2021
B	6-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]

@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]

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 · Accepted solution]

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