Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |