Forum Discussion

kalspiros's avatar
kalspiros
Icon for Helper I rankHelper I
4 years ago
Solved

Calculate with slicer date

Hi all,   I'm sorry, i'm sure the answer has been addressed again but from some quick search, i couldn't find it 😕 And TOTALYTD doesn't seem to do the trick for me. So: I'm trying to capt...
  • ValtteriN's avatar
    ValtteriN
    4 years ago

    Hi,

    Here is one way to do this:

    RT month =
    var _year = YEAR(MAX(Aggregation[Opened At]))
    var _month = MONTH(MAX(Aggregation[Opened At (Month)]))
    return

    CALCULATE(SUM(Aggregation[Duration(Secs)]),ALL(Aggregation),MONTH(Aggregation[Opened At (Month)])<=_month,YEAR(Aggregation[Opened At (Month)]=_year))

     

    The example is a bit different but the base logic is the same. Ping me with @ if you have questions about it.I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

    My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
     
kalspiros's avatar
kalspiros
Icon for Helper I rankHelper I
4 years ago

ValtteriN that works perfect! many thanks! interested on your opinion, why my second measure above didn't work? The [Month] is just the number of the month, so is the slicer. Kind of happy to see that i wasn't miles away 😄 

Thank you once again!

ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
4 years ago

kalspiros  The key difference is that you used FILTER. FILTER creates a table filtered with the conditions while using filter conditions in CALCULATE modify the filter context.