legalhustler
Well-known Member
- Joined
- Jun 5, 2014
- Messages
- 1,214
- Office Version
- 365
- Platform
- Windows
I have a Power Pivot column called "Timeliness" that has values such as After 2/1/2018, Before 2/1/2018, After 3/1/2018, Before 3/1/2018.
How do I create a IF statement that counts the rows for all the one's that are for After?
The Excel formula would be like =COUNTIFS($A$1:$A$5,"After*"), which would result in 2. But I'm not sure how to do it in DAX (since there is no COUNTIFS function). Should the DAX formula be in a Calculated Column or Measure?
How do I create a IF statement that counts the rows for all the one's that are for After?
The Excel formula would be like =COUNTIFS($A$1:$A$5,"After*"), which would result in 2. But I'm not sure how to do it in DAX (since there is no COUNTIFS function). Should the DAX formula be in a Calculated Column or Measure?
Last edited: