Forum Discussion

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

Visual based on previous periods from slicer date

Hi,   Thanks for dropping by.   Got this requirement whereby I seem to end up goign in circles. Just cant figure out what the best solution approach is.   Have a report with: 1. Sales Data (qu...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Mark1982 , if you select one month and want to see more than that, you need to have slicer on independent date table 

     

    //Date1 is independent Date table, Date is joined with Table
    new measure =
    var _max = maxx(allselected(Date1),Date1[Date])
    var _min = eomonth(_max, -6) +1
    return
    calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

     

     

    Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

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

Mark1982 , if you select one month and want to see more than that, you need to have slicer on independent date table 

 

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -6) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

 

 

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

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

Why havent I thought about this? Thank you very much.