Forum Discussion
Filter table rows by Date Table , where Main Table contains dates in 5 columns and can be duplicate
Hi users,
I need to filter my table as per selected date or date range from Date table column (refer left side of the image) and I need to filter weather the range of those dates contains in my 5 columns to get the ChosenSeat falls in that date range.
I'm trying to messing around, but can't get it working. Any help would be appreciated.
Thanks
10 Replies
- amitchandak
Super User
Anonymous , Create a date table join with all dates. One active, all other inactive. Create a formula to count based on all dates using userelation.
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
Appreciate your Kudos.Thanks amitchandak, Links looks very good,
But I think those still doesn't clear and gives my answer. I could easily change by date from 'dd mmmm yyyy' to 'dd-mm-yyyy'.
But I still need to filter out my data as based on the date range. Its a simple filter but my main table does contain duplicate dates and in all 5 column and I need that. In the above shown image , for selected date range, if my data will filter out for right hand side ticked rows, that will be the answer to my current issue.
Hope it makes sense, what i'm trying to achieve. But if you response does contains the solution, then that probabely I didn't understand it well, i think 🤔.
- amitchandak
Anonymous ,Can you share sample data and sample output in table format?
Hi Anonymous,
I'd like to suggest you unpivot your date fields then you cna simply filter across raw date fields.
Regards,
Xiaoxin Sheng
