Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Filtro MAT, YTD, QTR, MTH

Good morning, everyone: Dear please I would like if you help in something, I need a table that between two dates can show me all the dates according to the filter I choose, it can be the mobile y...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Syndicate_Admin , if you select a date and need more than that, you need an independent date table

 

example 12 month

 

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -12) +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