Forum Discussion
Helper IIIhelp: filter particular columns inside table visual by two dates
i have a table visual that shows the following:
laundry name - placed orders overall-placed orders- success orders
im filtering the table by countryName from countries table, laundryName from laundries table and i need to filter the table by 2 dates:
placed order date- completed order date (both fields are from orders table)
1st date should filter the placed orders overall- placed orders colomns ONLY
2nd date should filter the success orders colomn ONLY
note that placed orders overall-placed orders- success orders are measures that count number of orders based on their statuses
2 Replies
- Greg_Deckler
Community Champion
lawada - Having trouble visualizing this, can you post sample data and expected results? 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. - amitchandak
Super User
lawada , You can create a date table and join both the dates to same date table. one will be active another will inactive. Then you can create a measure with userelation to use date of your choice and calculate formula of your choice
In this example employee id is used in both cases. but you can use different column
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.
