Forum Discussion
pmadam
Helper II
Helper IIDAX HELP
I want to create Previous month sales measure. so i created Latest month and previous month measures. But when i create final measure to calculate sales for Previous month i get blank values Bel...
Hi pmadam ,
Would you please change your two measure to:
LATESTMONTH = CALCULATE(MAX('Time'[Month Num]),ALL('Time'),'Time'[CurrMonthFlag] = "Y") PM Ship Order Count = CALCULATE([Ship Order Count],FILTER(ALL('Time'), 'Time'[Month Num] = [PreviousMonth]))If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
v-deddai1-msft
Community Support
Community SupportHi pmadam ,
Would you please change your two measure to:
LATESTMONTH = CALCULATE(MAX('Time'[Month Num]),ALL('Time'),'Time'[CurrMonthFlag] = "Y")
PM Ship Order Count =
CALCULATE([Ship Order Count],FILTER(ALL('Time'), 'Time'[Month Num] = [PreviousMonth]))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai