topic Re: Cumul Total by month in DAX Commands and Tips

Cumul Total by month

Sofinobi — Tue, 14 Mar 2023 12:49:34 GMT

Hello All
i have Client Table with creation dates, statut (if the client is active or not), and if the client is not active i have the "Last Modification Date" column to show the inactive date.

i want to represent the number of active client in a line chart by months, so i need the cumul sum of active client
please if you can help
the result wanted, see image

Nb client actif by month

thank you so much

Re: Cumul Total by month

Aburar_123 — Tue, 14 Mar 2023 13:00:59 GMT

Hi Sofinobi ,

Please pull the date field to the X-Axis, ClientID to Y-Axis (Make it as Count) then place the Active flag to Visual level filter and make it as 'Y'.

Re: Cumul Total by month

Sofinobi — Tue, 14 Mar 2023 13:19:00 GMT

thank you o much for the answer, but sorry i don't understand your approach,

can you explain me more about that active flag?
thank you