help: filter particular columns inside table visual by two dates

[lawada]

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

[amitchandak]

@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

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

In this example employee id is used in both cases. but you can use different column

https://youtu.be/e6Y-l_JtCq4

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-Y...


Appreciate your Kudos.

[Greg_Deckler]

@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.