How to find Region 1 region 2 wise profit values in 45 days

[MSMKM]

Hi Team,

i have sales data in that how to find out Region 1 Region 2 wise and profit with 45 days. 

It should be one measure it self we have to get it ?

how we can achieve on this.

[Anonymous · Accepted solution]

Hi @MSMKM ,

I think you can try measure as below to achieve your goal.

Measure = 
CALCULATE(SUM('Table'[Sales]),FILTER('Table','Table'[Date]>= TODAY() - 45))

My Sample:

Best Regards,
Rico Zhou

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

[FreemanZ]

https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/m-p...