Calculated Sales From January to Selected Month

[Juampe]

Hi all there is my problem.

"I need to select a date (month) (ex: April-19) and in the graph I only want to show the values From January of this year to April"

Detail:

• Information: Montly
• Using Master Calendar
• I tried DATESYTD but it doesnt work due to it returns me an acumualtive sales

Any idea? 

[Greg_Deckler · Accepted solution]

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

[Icey · Accepted solution]

Hi @Juampe ,

You can refer to this post.

Best Regards,

Icey

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

[Icey]

Hi @Juampe ,

Is this problem sloved?

If it is sloved, could you kindly accept it as a solution to close this case?  

If not, please let me know.  

Best Regards

Icey