Forum Discussion

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

Find max date less than slicer selected date

I feel like this should be really easy, but have spent many hours trying every possible solution I've seen, and none have worked.   I have a date table including Date, MonthEndDate, OneMonthPrior, ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    StaceyG , try like

     

    VAR PriorMonthEndDate = eomonth(SELECTEDVALUE('Date'[MonthEndDate])-1)
    VAR TotalTrx = CALCULATE(SUM(Transactions[Total Trx]), FILTER('Transactions', 'Transactions'[MonthEndDate]=PriorMonthEndDate ))

     

    selectvalue will work in measure, it will not work in new column

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

StaceyG , try like

 

VAR PriorMonthEndDate = eomonth(SELECTEDVALUE('Date'[MonthEndDate])-1)
VAR TotalTrx = CALCULATE(SUM(Transactions[Total Trx]), FILTER('Transactions', 'Transactions'[MonthEndDate]=PriorMonthEndDate ))

 

selectvalue will work in measure, it will not work in new column

StaceyG's avatar
StaceyG
Icon for Helper I rankHelper I
4 years ago

amitchandak thank you for this suggestion!  It certainly seems like it should work, but when I applied it to my scenario it did not.  I don't get an error with the measure, but when inserted in the table, the column is blank.  Any idea why?