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 J:J is a data reference
Account Level E5 is a date - we are wanting to count those dates in the last 3 months so "greater than the date in E5)
I am essentially counting the number of instances where a client accessed an application (by date) in the timeframes 3, 6 and 12 months.
4 Replies
amiller5 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
I think these can help
https://medium.com/chandakamit/power-bi-when-i-felt-lazy-and-i-needed-too-many-measures-ed8de20d9f79
Appreciate your Kudos.That may have helped a little.
I added a Date table to relate all my dates.
I need to create 3 month, 6 month, and 12 months usage count, by client name, for each table (Vue, IE report activity, and IMIC report activity) based off the review month date.
I tried this calc within the Vue table: and got an error when I put in a matrix as a value.
Vue usage 3 months = CALCULATE(SUM(Vue[Fixed Client name]),DATEADD('Date'[Date],-3,MONTH))Here is how my tables relate.Ashish_Mathur - any ideas???
Hi,
I do not know what you are trying to do. Replace SUM(Vue[Fixed Client name]) with DDISTINCTCOUNT(Vue[Fixed Client name])
