Forum Discussion

Cadenze's avatar
Cadenze
Icon for Helper II rankHelper II
2 years ago
Solved

Combined conditional measure that depends on current date

I have a pickle that I'm struggling with and I need someone really competent in DAX to help me. I need one measure that is one thing if this month is selected, and another if we go back in time. It h...
Need Help
  • Cadenze's avatar
    Cadenze
    2 years ago

    I ended up with this construct that yielded the required result (in case anyone with the same problem visits this post):

    OpenamtNow =

    CALCULATE( SUM(OrderBook[Open amount]),LASTNONBLANK('Date'[Date],

    CALCULATE(SUM(OrderBook[Open amount]), FILTER( ALL('Customers'),1))

    ))

Cadenze's avatar
Cadenze
Icon for Helper II rankHelper II
2 years ago

That looks good - however, it leaves the open amount for this month totally empty. Maybe I dreamt something up that is not doable. Let me ponder - I will supply a pbix for a more detailed problem description. Thank you anyway 🙂