Need help with DAX Formula
Hi I need help for a formula. I am only getting EOM for the current month using this formula. How can i get for the remaining months as well. I am currently using Qty Available Last Day of Month = VAR _SKU = SELECTEDVALUE('DEMAND & SUPPLY (3)'[2nd Item Number]) VAR LastDayOfMonth = EOMONTH(MAX('DEMAND & SUPPLY (3)'[Sched Pick].[Date]), 0) RETURN CALCULATE ( sum ( 'DEMAND & SUPPLY (3)'[Quantity Available ] ), // Replace 'YourTable' and 'Quantity' with your actual table and quantity column names FILTER ( ALL ( 'DEMAND & SUPPLY (3)' ), // Remove any existing filters on 'YourTable' 'DEMAND & SUPPLY (3)'[Sched Pick].[Date] = LastDayOfMonth && 'DEMAND & SUPPLY (3)'[2nd Item Number]=_SKU ) )
