Forum Discussion
Seperate filter for seperate columns in a table visual.
- 2 years ago
Mihir2203 , You can use two disconnected or atleast one disconnected date table
//Date1 is independent Date table, Date is joined with Table
Stock Quantity measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = minx(allselected(Date1),Date1[Date])
return
calculate( sum(Table[Stock Quantity]), filter('Table', 'Table'[Date] >=_min && 'Table'[Date] <=_max))//Date2 is independent Date table
new measure =
var _max = maxx(allselected(Date2),Date2[Date])
var _min = minx(allselected(Date2),Date2[Date])
return
calculate( sum(Table[Sales Quantity]), filter('Table', 'Table'[Date] >=_min && 'Table'[Date] <=_max))Need of an Independent/disconnected Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
Power BI How to use/compare two Date/Period slicers: https://youtu.be/WSeZr_-MiTg
Hi amitchandak,
Thanks for the solution. Its working as expected