Forum Discussion
Solved
DAX: Calculate, Filter problem, dead stock calculation
Hey guys, Im still new to DAX. Im trying to calculate measure which is called Dead stock. The measure definition is following, its Inventory status for items, which havent been sold for 8 previous w...
Yep I agree, calculated column approach is a better design. And you can use EARLIER function for the last 8 weeks logic. Here is a link to EARLIER function (https://msdn.microsoft.com/en-us/library/ee634551.aspx)
Hope this helps.
Check out the Chicagoland Power BI User Group
Yep I agree, calculated column approach is a better design. And you can use EARLIER function for the last 8 weeks logic. Here is a link to EARLIER function (https://msdn.microsoft.com/en-us/library/ee634551.aspx)
Hope this helps.
Check out the Chicagoland Power BI User Group
thank you, its really helpful ( I knew, that I misunderstood DAX concept a little now are things much clearer too me).