Need help with DAX Formula

[ahmer_malick]

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

        )

    )

[tayloramy]

Hi @ahmer_malick, 
Only users in your org are able to access that file

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.