How to calculate sum of amount where orderdate between Max of date

[Anonymous]

Hi @Powers 

Thank you very much amitchandak for your prompt reply.

Have you solved your problem? If you haven't already, here are some ways to do it:

"Order Table"

"Date"

Date = CALENDAR("9/10/2024", "10/5/2024")

Create a measure.

Amount Total = 
var _MaxDate = MAX('Date'[Date])
var _MinDate = MIN('Date'[Date])
RETURN
CALCULATE(
    SUM('Order Table'[Amount]),
    FILTER(
        ALL('Order Table'),
        'Order Table'[OrderDate] >= _MinDate
        &&
        'Order Table'[OrderDate] <= _MaxDate
    )
)

Here is the result.

If you still have problems, it is best to provide the pbix file and be careful to delete sensitive data.

Regards,

Nono Chen

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

[Powers]

Hi @Anonymous, Thanks for your reply. Can you please find the below post?. In the below post I have mentioned the requirement and as well as the sample data.
I am looking for the solution for the below post. If you can solve the below problem then it will be great.

https://community.fabric.microsoft.com/t5/Desktop/How-to-calculate-sum-of-Product-purchase-Sold-between-Min-and/m-p/4215761

Best Regards,
Powers

[amitchandak]

@Powers , you need to have a measure like

Only In Min Max Month =
var _min = minx(allselected('Date'), 'Date'[Date])
var _max = maxx(allselected('Date'), 'Date'[Date])
return
CALCULATE(sum('Table'[Qty]), FILTER('Date',eomonth('Date'[Date],0) = eomonth(_min, 0) && eomonth('Date'[Date],0) =eomonth(_max, 0)))

[Powers]

Hi @amitchandak,

Thanks for your reply. I have tried your solution but it's not working.