Forum Discussion
Disitinct count with condition across column
Hello guys, Please how can i return the results below using a DAX formula? Months Jan Feb Mar Apr May Jun Jul Street-Number NG-PHC-21 80 86 82 70 65 80 4...
Hi Anonymous ,
Not sure whethear you wanted this as a visual table, but I dropped the street names on the table, and created this measure.
March = IF(max(OHMS[Jan])>=80 && MAX(OHMS[Feb] ) >=80 && MAX(OHMS[Mar]) >= 80, 1,0)
I would note that you say exceeds, but in your summary table you use >= to get the value.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel