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...
Hi guys,
I have a large dataset (too big for excel) that I wanted to look at in Power BI.
Each row of data is a transaction. Item number, store and month of transaction.
I need to count the number of different months. So for example for Item = 10, Store = 1200, since a transaction occurs in month 3 and 4, the final result should be 2 (in red). For item 12 and store 1100, there are 6 transactions but spread out accros 3 different months, so the answer should be 3 (in red). The colomns after Month are the calculations that i used in excel to obtain the desired outcome.
Can someone recomend a solution in Power BI? I have over 10 million lines of such info.
Much appreciated!