Forum Discussion
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 month is needed
Please can any can share me way how to do it please.
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
2 Replies
- Greg_Deckler
Community Champion
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 Thankyou for the solution .It Worked.Sorry for late reply i went sick.
