Forum Discussion
Helper IICumulative Total within Date Range from 2 Date Tables
Community Championawolf88 You can either use an inactive relationship in conjunction with CALCULATE and USERELATIONSHIP or do it the No CALCULATE way. See this post for examples of both:
Solved: Re: No CACULATE challenge - Microsoft Power BI Community
Helper IIHi Greg,
appreciate the rapid response and input!
Seems the userelationship is definitely the way to go for me. I've tried implementing the tips in the article and am now able to display the corresponding cumumlative Sales total by INSERTED Date (via userelationship). What I can't seem to understand though is that the provided Sales Revenues are only in the Month of April, yet it is showing me the same figures for every following month as well?
The measure I'm using looks like such and I can't understand why it would be misinterpreting months:
Any ideas why?
Thanks in advance!
Best,
Alex