Forum Discussion

faiqsadiq1's avatar
faiqsadiq1
Frequent Visitor
3 years ago
Solved

calculate inventory

  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 mon...
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    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
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

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