Forum Discussion
P-H
2 years agoNew Member
Calculate return no value
Hi i'm calculating sales over month. with a year to date total column. it is working fine if there is sales for the current month but if there is no sales, it is not calculating for this month.
=CALCULATE (
[Sum of LINETOTAL],
FILTER (
ALL ( Query[MonthOrder] ),
Query[MonthOrder] <= MAX (Query[MonthOrder] )
)
)
ex of the result if there is no sales in november
order oct---YTD OCT---order nov---ytd NOV --- order dec--- YTD DEC
1000 5000 empty empty --- 1000 6000
what i want is to have 0 for order nov and 5000 for YTD Nov
1 Reply
- FreemanZ
Super User