Forum Discussion

87seven's avatar
87seven
Frequent Visitor
2 years ago

Filtering table before grouping using date slicer

In powerbi I have 2 tables in my model.First table has unique orders ids and 2nd table has order transactions. Both tables have a date column.I would like to have first table with unique orders ...
Data Modeling
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi 87seven ,

 

First, create an unrelated schedule, then use this as a slicer. then create this MEASURE for filtering:

Table 2 = SUMMARIZE('Table',[Date])

Filter = var _min = MIN('Table 2'[Date])
var _max = MAX('Table 2'[Date])
RETURN CALCULATE(SUM('Table'[Cost]),FILTER(ALLEXCEPT('Table','Table'[OrderID]),[Date]>=_min&&[Date]<=_max))

 

Best regards,
Community Support Team_ Scott Chang