Forum Discussion
Count if - Index
Hello - I need help formulating the following Excel formula into the correct Dax syntax: =COUNTIFS(IMIC!A:A,INDEX(B:B,ROW()),IMIC!J:J,">"&'Account Level'!$E$5) IMIC A:A is unique client name IMIC ...
Hi,
I do not know what you are trying to do. Replace SUM(Vue[Fixed Client name]) with DDISTINCTCOUNT(Vue[Fixed Client name])
I am trying to do the following Excel formula but in PowerBi
=COUNTIFS(IMIC!A:A,INDEX(B:B,ROW()),IMIC!J:J,">"&'Account Level'!$E$5)
IMIC A:A is unique client name, indexing column B:B for the matching client name
IMIC J:J is a date reference
Account Level E5 is a specific date within a 3 month timeframe of the date reference in J:J