calculate inventory

[faiqsadiq1]

Hi I hope you would be fine

.I want to show month wise inventory of data and that is what we have on last date of month.I dont want to sum every day data but only what is in last day of month is needed
Please can any can share me way how to do it please.

[faiqsadiq1]

@Greg_Deckler  Thankyou for the solution .It Worked.Sorry for late reply i went sick.

[Greg_Deckler · Accepted solution]

@faiqsadiq1 You can do something like:

Measure = 
  VAR __Max = MAX('Table'[Date])
  VAR __EOM = EOMONTH(__Max,0)
  VAR __Result = SUMX(FILTER('Table',[Date] = __EOM),[Value])
RETURN
  __Result