Forum Discussion
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 definit...
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.
hi himanshu56
thanks for responding, monthcode is a date column, so that woudn't be the issue i think? month date looks like this
| 01/09/2016 |
and in the data model it is seen as a date datatype
then may be you need make some changes in the expression which you have used.
Below link might help you:
Thanks,
Himanshu