cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
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

thank you Ashish it worked.

You are welcome.


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

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors