cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
erezbenmoshe Regular Visitor
Regular Visitor

Sum non-unique values over months

Hello,

 

I not sure what should be the subject of my question, but here is what I am struggling with doing.

I created two measures, [New Customers] and [Returning  Customers] that count users. These users are shown in the following visualization. The chart shows those measures by months (month names are in Hebrew):

Capture.JPG

Now, I have to create a new mesure that sums up values over months.  I.e., finds the total number of New and reutrning users.

For returning users, the measure should provide: 253+376+596+ ... +482+702. The new meausre has to count the same user twice if they returned over two month.  

 

How can I do that? How can I split a meausre by month and then sum over months?

 

Thanks,

Erez

1 REPLY 1
Super User
Super User

Re: Sum non-unique values over months

Hi,

 

Does this work?

 

=CALCULATE{[Returning Customers],DATESYTD(Calendar[Date],"31/12/"))

 

In your visual, the year and month on the x-axis should be dragged from the Calendar Table.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 280 members 3,191 guests
Please welcome our newest community members: