Forum Discussion
DAX Query Clarification
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 ...
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
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 ,
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