Forum Discussion
COUNTIFS in DAX
Can anybody please help with a DAX question. I have a report in Excel that counts the items that make up an invoice. I have atached a screenshot with the Excel formula highlighted. I am trying to rec...
Thanks, I have tried the calculated column and it is nearly there but not quite right. As you can see from the results below. It should be counting 3 items, as one of the locations is Manchester. How does the EARLIER function work?
BrianConnelly
Resolver III
Resolver IIIJust add another condition,
&& Inv[City]=EARLIER('Inv'[City])You will want to add any conditions that make the record the same as the previous. If my anyswer helped, please mark it.