Forum Discussion

P-H's avatar
P-H
New Member
2 years ago

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

  • hi P-H ,

     

    Seems doable but also strange. Try to pose some sample data, ideally with expected result.