Forum Discussion

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago
Solved

For what reason would CLOSINGMONTHBALANCE be 0?

I have the following measure (CLOSINGBALANCEMONTH(sum('Patient Numbers'[ClosingBalance]),'Patient Numbers'[MonthCode]))

 

but its showing 0, any idea why it wouldn't be returning values?  i definitely do have datea, for example if i just did a sum on the column data is returned, wondering what i need to check?

Need Help
  • vanessafvg's avatar
    vanessafvg
    9 years ago

    Hi there thank you, i found the issue i was being daft, my date filter in my slicer went later than when i had data.

6 Replies

  • himanshu56's avatar
    himanshu56
    Icon for Resolver II rankResolver II
    9 years ago

    Hi vanessafvg

     

    The syntax is using CLOSINGBALANCEMONTH(<expression>,<dates>[,<filter>])

     

    where the dates argument can be any of the following:

    • A reference to a date/time column.

    • A table expression that returns a single column of date/time values.

    • A Boolean expression that defines a single-column table of date/time values.

    Make sure 'Patient Numbers'[MonthCode] follows any one of the above date argument.

     

    Thanks,

    Himanshu