Need help with my formula

[cbouichi]

Hello everybody.

Need help with my formula im still learning the DAX languages.

What i want is that we look in column "Deelopdracht gereed Ja/nee. if is Ja than check the day differents between Column "Bonnen verstuurd op" With "Deelopdracht klaar op" must be smaller or equal to 7. then oke and give results in days

If Column "Deelopdracht gereed ja/nee" is Nee check day differents between Column "Bonnen verstuurd op" With Column "Geplande einddatum project". must be smaller or equal to 7. then oke.

This is what i came up with.

Bonnen verstuurd binnen (dagen) = IF([Deelopdracht klaar op].[Day]>[Bonnen verstuurd op]; DATEDIFF([Bonnen verstuurd op];[Geplande einddatum project];DAY); DATEDIFF([Geplande einddatum project]; [Bonnen verstuurd op];DAY); IF([Deelopdracht gereed ja/nee]"nee",Projectstatus[Deelopdracht klaar op].[Day]Datediff([Geplande einddatum Project])

I hope its clear for everybody.

[v-chuncz-msft · Accepted solution]

@cbouichi,

You may refer to the following DAX that adds a calculated column.

Column =
SWITCH (
    Table1[Deelopdracht gereed ja/nee],
    "Ja", IF (
        Table1[Deelopdracht klaar op] <= Table1[Bonnen verstuurd op],
        DATEDIFF ( Table1[Deelopdracht klaar op], Table1[Bonnen verstuurd op], DAY ),
        - DATEDIFF ( Table1[Bonnen verstuurd op], Table1[Deelopdracht klaar op], DAY )
    ),
    "Nee", IF (
        Table1[Geplande einddatum project] <= Table1[Bonnen verstuurd op],
        DATEDIFF (
            Table1[Geplande einddatum project],
            Table1[Bonnen verstuurd op],
            DAY
        ),
        - DATEDIFF (
            Table1[Bonnen verstuurd op],
            Table1[Geplande einddatum project],
            DAY
        )
    )
)

[cbouichi]

Thankx for the help.

Greetings from the Netherlands