Forum Discussion
Create one filter for two columns with Year
- 5 years ago
mic_rys , I think you have to create a common year table and join it both years. One will be inactive, You can active that in measure using use relationship
This with date, you need for Year
New Table
Year = distinct(union(distinct(Table[implemented]),distinct(Table[deleted])))
Assume active join implementedmeasure
implemented = countrows(Table)deleted = calculate(countrows(Table), userelationship(Table[deleted], Year[implemented]))
mic_rys , I think you have to create a common year table and join it both years. One will be inactive, You can active that in measure using use relationship
This with date, you need for Year
New Table
Year = distinct(union(distinct(Table[implemented]),distinct(Table[deleted])))
Assume active join implemented
measure
implemented = countrows(Table)
deleted = calculate(countrows(Table), userelationship(Table[deleted], Year[implemented]))
the simpliest solution looks the best! thank you!