Showing Month End Customer Count Daily

enestkm — Fri, 19 Nov 2021 13:04:00 GMT

Hi, many thanks in advance for your help

I need some help on writing the calculate statement that would assign the "month end customer base number" to all dates in that particular month

The month end values for september base figure is 41059 and october is 41093

I need all the rows in the daily view column to populate 41059 for september and same logic should apply to October and all october dates should populaete 41093

this is the current metric i use

Daily View =

CALCULATE (

AVERAGEX (SUMMARIZE ( Dates, Dates[Year], Dates[MonthInCalendar] ),
[Customer Base]),

REMOVEFILTERS ( Dates ))

Re: Showing Month End Customer Count Daily

amitchandak — Fri, 19 Nov 2021 15:44:56 GMT

enestkm , Try closingbalancemonth, if that can help

https://www.youtube.com/watch?v=yPQ9UV37LOU

Re: Showing Month End Customer Count Daily

enestkm — Fri, 19 Nov 2021 16:02:44 GMT

thanks amitchandak - it worked perfectly !

topic Re: Showing Month End Customer Count Daily in DAX Commands and Tips

Showing Month End Customer Count Daily

Re: Showing Month End Customer Count Daily

Re: Showing Month End Customer Count Daily