Hi there,
Just starting to learn DAX and coming across some trickier calculations that I am getting stuck on. I have 4 years of [ProductID], [Date], and [TotalSales]. My products are in my ProductID column. My approach is to use DistinctCount([ProductID]) with the following filters: Sales in 2013 >0, Sales in 2014 >= 0, Sales in 2015 >= 0, Sales in 2016 > 0.
Not sure if I should be using CALCULATE, IF, or FILTER given that I have multiple filters..
Any help would be greatly appreciated.
Thanks
Just starting to learn DAX and coming across some trickier calculations that I am getting stuck on. I have 4 years of [ProductID], [Date], and [TotalSales]. My products are in my ProductID column. My approach is to use DistinctCount([ProductID]) with the following filters: Sales in 2013 >0, Sales in 2014 >= 0, Sales in 2015 >= 0, Sales in 2016 > 0.
Not sure if I should be using CALCULATE, IF, or FILTER given that I have multiple filters..
Any help would be greatly appreciated.
Thanks