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

How to calculate TOTALYTD for users registered in May

Hi All,

 

Can anyone help with DAX to calculate Total Year to Date for May'20 (I have Report Date slicer) but only for customers who have register status in reporting month. Client want to count all prior months sale even if customer was not registered on the begining of the year, and we should disregard customers sale who are not registered in reporting month.

Here is example data set and expected result for May'20 TOTALYTD sale = $500

My date table/date field is:  dim_calendar[date],  and 'f_sale' table as below:

 

AgnesP_0-1600556984162.png

Any ideas will help.

Regards,

Agnes

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

3 REPLIES 3
Highlighted
Super User III
Super User III

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Highlighted

thank you Ashish it worked.

Highlighted

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors