Forum Discussion
Recurrence per month
Guys, good morning!
I have a table with the following columns (Date, product, quantity), I need to know how many times the product was in my inventory, this per month.
example during the period of 12 months a product appears in my inventory in 7 different months, I don't care about the quantity of products, just in how many months it appeared
Vitor_sp_bo , Create a month year column in table and try a measure like
countx(summarize(Table, Table[Month Year], Table[Product]),[Product])
Month Year = FORMAT([Date],"mmm-yyyy")
2 Replies
Vitor_sp_bo , Create a month year column in table and try a measure like
countx(summarize(Table, Table[Month Year], Table[Product]),[Product])
Month Year = FORMAT([Date],"mmm-yyyy")
Thank you very much, that was exactly it, I appreciate your time and dedicated help. Have a great day.
