Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
ArchStanton
Impactful Individual
Impactful Individual

Help with evaluating some DAX code

Hi,

 

I'm struggling to work out how this piece of code is being being evaluated, in particular what is being calculated first, second and so on. If some could break it down to show what each step is in order it would be a great help.

 

Also, Is there a way of making this code simpler using Variables?

Days ERT to Outcome = 
IF (
    NOT ( ISBLANK ( 'Cases'[ERT Start FlagDate] )),
    IF (
        ISBLANK ( 'Cases'[formofauthorityreceiveddate] ),
        DATEDIFF (
            IF (
                'Cases'[Created Date] > 'Cases'[ERT Start FlagDate],
                'Cases'[Created on],
                'Cases'[ERT Start FlagDate]
            ),
            IF ( ISBLANK ( 'Cases'[ERT End FlagDate] ), NOW (), 'Cases'[ERT End FlagDate] ),
            DAY
        ),
        DATEDIFF ( 'Cases'[ERT Start FlagDate], 'Cases'[ERT End FlagDate], DAY )
    ),
    BLANK ()
)

Thanks,

 

 

2 ACCEPTED SOLUTIONS
jdbuchanan71
Super User
Super User

IF statements work from the top in so it check 1, the 2 etc:

jdbuchanan71_1-1692365439029.png

It startts with 1 and IF 'Cases[ERT Start Flag Date] is not blank it goes to section A which starts the 2 check, if it is blank it gos to B and returns a BLANK().

 

View solution in original post

Hi @ArchStanton 

 

The explanation from @jdbuchanan71 is perfect. Regarding your second question, you can use variables in this way:

 

Days ERT to Outcome = 

var _startFlag= ISBLANK ( 'Cases'[ERT Start FlagDate] )
var _endFlag= ISBLANK ( 'Cases'[ERT End FlagDate] )

IF (
    NOT ( _startFlag),
    IF (
        ISBLANK ( 'Cases'[formofauthorityreceiveddate] ),
        DATEDIFF (
            IF (
                'Cases'[Created Date] > 'Cases'[ERT Start FlagDate],
                'Cases'[Created on],
                'Cases'[ERT Start FlagDate]
            ),
            IF ( _endFlag , NOW (), 'Cases'[ERT End FlagDate] ),
            DAY
        ),
        DATEDIFF ( 'Cases'[ERT Start FlagDate], 'Cases'[ERT End FlagDate], DAY )
    ),
    BLANK ()
)

 

However, as you can see, it doesn't make much sense. Variables avoid repetitive calculus, but in this case, you don't have repetitive pieces

View solution in original post

3 REPLIES 3
jdbuchanan71
Super User
Super User

IF statements work from the top in so it check 1, the 2 etc:

jdbuchanan71_1-1692365439029.png

It startts with 1 and IF 'Cases[ERT Start Flag Date] is not blank it goes to section A which starts the 2 check, if it is blank it gos to B and returns a BLANK().

 

Hi @ArchStanton 

 

The explanation from @jdbuchanan71 is perfect. Regarding your second question, you can use variables in this way:

 

Days ERT to Outcome = 

var _startFlag= ISBLANK ( 'Cases'[ERT Start FlagDate] )
var _endFlag= ISBLANK ( 'Cases'[ERT End FlagDate] )

IF (
    NOT ( _startFlag),
    IF (
        ISBLANK ( 'Cases'[formofauthorityreceiveddate] ),
        DATEDIFF (
            IF (
                'Cases'[Created Date] > 'Cases'[ERT Start FlagDate],
                'Cases'[Created on],
                'Cases'[ERT Start FlagDate]
            ),
            IF ( _endFlag , NOW (), 'Cases'[ERT End FlagDate] ),
            DAY
        ),
        DATEDIFF ( 'Cases'[ERT Start FlagDate], 'Cases'[ERT End FlagDate], DAY )
    ),
    BLANK ()
)

 

However, as you can see, it doesn't make much sense. Variables avoid repetitive calculus, but in this case, you don't have repetitive pieces

ArchStanton
Impactful Individual
Impactful Individual

Really grateful for your reply as well, many thanks

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.