Forum Discussion
unique month calculation
Hi, I have a large data set of transactions with information regarding Item, Stores and Month. I need to calculate, for each row, what is the amount of unique months that are associated with tha...
You can use this formula
Column =
CALCULATE (
DISTINCTCOUNT ( Table1[Month] ),
ALLEXCEPT ( Table1, Table1[Item number], Table1[Stores] )
)