Variance based on date selected

[topazz11]

Can someone please help me with creating these measures ? I am trying to find a way to calculate variances between two dates selected for cumulative one and not comulative one? 

[amitchandak · Accepted solution]

@topazz11

Refer my blog how to work with two date ranges : https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

Appreciate your Kudos.

[topazz11]

Thanks,

how do I get the varoance between the two?

[dax]

Hi @topazz11 , 

 I am not clear about your logic(why apple is 5 and grape is 4, and the cumulative logic)? So if possible could you please explain this to me in details ? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.