Forum Discussion
Distinct Count selected elements in a column
Hi, I'm struggling with a calculated column. I'd like to make a line diagram to compare 2017 - 2019 revenue trends with 2020, with the possibility to filter between 2017 - 2019. So if you...
OliverMatsik , You can create two slicers one on depending on the date table and another on an independent date.
From the date table, you can take distinct count of year and divide.
Something like this. You have use year in place of dates
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601