Hi!
I have a table which has the following columns:
Date - Data1 - Data2 - OtherData1 - OtherData2
I came up with some formulas to count my datas monthly. I have 12 tables with this kind of formula in it:
Where B12 is the year and A213 is my month number. My first try on the "date filter" looked like that:
And it wasn't working so I thought it was because the 31 wasn't a good idea for non-31-days-months but none of the formulas above are working.
Any idea why ?
(BTW, IDK why it's not working but I have data in my table for months 10, 11 and 12 and the only calculation tables that are calculating data are the ones for months 9 and 10. The results are the same in these two tables and are counting all my Table1[Data1] and [Data2] (the count is not monthly))
Any help appreciated
Bookmarks