Forum Discussion
Solved
Finding repeated values over consecutive dates
I hope I can describe this correctly. I am building a report, and I need to be able to create a column or measure that essentially says "Alert" or "Okay" if a certain condition is met. I ha...
I need to create a column which count the product type in column A in the fashion as shown in column B. If consecutive months show same product then it should be considered as 1 count. For e.g; the product "a" is counted 2 times because it appeared 2 times but not in consecutive months.
Hi,
Share some data, describe the question and show the expected result.