Forum Discussion

Datanik's avatar
Datanik
Frequent Visitor
3 years ago
Solved

Multi Date column in calculate

Hello, colleagues. Please help me in solving my problem. I have a spreadsheet with payments for different sales dates. I need to get payments for new sales and old sales within the current payment ...
Need Help
  • Datanik's avatar
    Datanik
    3 years ago

    I was able to find a solution after all. 
    thank you all

    payment n.d. = 
VAR minDate = MINX( allselected('date') , 'date'[Date] )
VAR maxDate = MAXX(allselected('date') , 'date'[Date] )
RETURN
CALCULATE([payment all], filter( deals_payments,deals_payments[date_deal] >=minDate && deals_payments[date_deal] <=maxDate))

payment o.d. = [payment all] - [payment n.d.]

payment all = SUM(deals_payments[amount])
Datanik's avatar
Datanik
Frequent Visitor
3 years ago

I was able to find a solution after all. 
thank you all

payment n.d. = 
VAR minDate = MINX( allselected('date') , 'date'[Date] )
VAR maxDate = MAXX(allselected('date') , 'date'[Date] )
RETURN
CALCULATE([payment all], filter( deals_payments,deals_payments[date_deal] >=minDate && deals_payments[date_deal] <=maxDate))

payment o.d. = [payment all] - [payment n.d.]

payment all = SUM(deals_payments[amount])