Forum Discussion

Guyakobov's avatar
Guyakobov
Icon for Helper II rankHelper II
5 years ago

Column by chosen dates

Hi,     I want to create a table based on the last 2 dates from the selected date filter. If the filter is for the whole of September, then the table will show only the last 2 days 30.9 and ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Guyakobov , Try a measure like


measure =
var _max =maxx(allselected(Date), Date[Date])
return
calculate([measure], filter(Date, date[date] >= _max-1, date[date]<=_max))

 

or

 

measure =
var _max =maxx(allselected(Date), Date[Date])
return
sumx(values(date[date]),if(max(date[date]) >= _max-1, max(date[date])<=_max , [meausre], blank()))

  • Guyakobov's avatar
    Guyakobov
    Icon for Helper II rankHelper II
    5 years ago

    HI, 

     

    thank you for your reply! 

     

    I tried it, but I can not use measures as in column in the matrix table.