DAX Query Clarification

[Anonymous]

Hi,

I am having a few issues troubleshooting a DAX Query on the following.

I need to return a count value where by "ETA_Disch" is more then 7 Days old, & the "Recognized_WIP" is showing 0

The current EXCEL foruma ustilised is =IF(AND(TODAY()-BS15>7,BB15>1),1,0)

Attached SS for review.

Thanks in adance for any assistance.

[harshnathani]

Hi @Anonymous ,

var _a = MAX('Table'[ETA_Disch])

var _dd = DATEDIFF(Today(),_a,DAY)

RETURN

IF( _dd > 7 && 'Table'[Recognized_WIP]>1,1,0)

Regards,

Harsh Nathani

[Anonymous]

Hi Harsh,

Thanks for your help here.

Apologies for the delay, I instered the below query and it returnd a value but only 0 and no 1 counts.

Please see attached for your reviewScreen Shot

[harshnathani]

Hi @Anonymous ,

Please create a Calculated Column

var _a = 'Table'[ETA_Disch]

var _dd = DATEDIFF(_a,TODAY(),DAY)

RETURN

IF( _dd > 7 && 'Table'[Recognized_WIP]>1,1,0)

Regards,

Harsh Nathani

[harshnathani · Accepted solution]

@Anonymous ,

You can also try

var _a = 'Table'[ETA_Disch]

var _dd = DATEDIFF(_a,TODAY(),DAY)

RETURN

IF( _dd > 7 && 'Table'[Recognized_WIP] = 0,1,0)

Regards,

HN