Forum Discussion
Helper ILinking 1 Date Column to Multiple Date Columns
I've got multiple (6) columns which are whether a service is enabled or not (1 or 0). I then have a column for each service which is the date the service was enabled. I have linked each of these dates to the date table so that i can use one date slicer on a page and filter each service columns, so if i selected October it would show me all services enabled in October (or show 0 if they were enabled outside of October).
My problem is that I have a master column which returns 1 when any of the services are enabled. I want this column to be linked to the date table, where if any of the 6 service dates enabled are within the date range selected then it would show in the filter. I originally thought of using the minimum of each of these 6 dates but then i realised it would return 0 if the first date enabled is not in the slicer date range, i would still want it to return 1 if another service enabled date was in that date range.
Any ideas??
1 Reply
- Greg_Deckler
Community Champion
RossP96 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
