Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
My table structure is more or less as follows (projects)
Title Start date End date
Proj A 01.01.2018 31.12.2018
Proj B 01.01.2018 30.04.2019
Proj C 01.09.2018 31.01.2019
Now I would need to have a filter of the data by year (not the full date). In the above scenario, I need to be able to get "Proj B" and "Proj C" returned if I select either 2018 or 2019 as my filter/slicer.
Thanks for help!
Solved! Go to Solution.
HI @lkarolak,
Current power bi filter not works on multiple date column, you need to create a table to store expand detail date form date columns and filter on detail date.
Spread revenue across period based on start and end date, slice and dase this using different dates
Regards,
Xiaoxin Sheng
HI @lkarolak,
Current power bi filter not works on multiple date column, you need to create a table to store expand detail date form date columns and filter on detail date.
Spread revenue across period based on start and end date, slice and dase this using different dates
Regards,
Xiaoxin Sheng
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |