topic Re: DAX Query Clarification in DAX Commands and Tips

DAX Query Clarification

Anonymous — Wed, 03 Jun 2020 05:32:00 GMT

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.

Anonymous — Wed, 03 Jun 2020 05:45:48 GMT

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 — Tue, 09 Jun 2020 01:17:48 GMT

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 review

Anonymous — Tue, 09 Jun 2020 03:42:54 GMT

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

Anonymous — Tue, 09 Jun 2020 03:45:06 GMT

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,