Forum Discussion
Using 2 Date Fields as One Slicer
Hi dplank
You can Append both table and make few changes in the model as below.
1. Closure Table : Rename the closure date to "Date" and add new column "Category" with values "Closure"
Name Units Date Category X XX 8/10/2018 Closure 2. FundingTable : Rename the Funding date to "Date" and add new column "Category" with values "Funding"
Name Units Date Category Y YY 8/20/2018 Funding 3. Append both tables. All 3 steps should be done in Power Query.
4.Create slicer based on "Date" field , and now if you select 2018 Aug, you will get both Closing and Funding data.
Thanks
Raj
Hi dplank
In your desktop, go to Home- > Edit Queries , that will take you to Query Editor / Power Query.
Yes, if you follow the above steps you can do those calculations.
Thanks
Raj
Hi Anonymous
I am still not able to get the results I need. When I put the date field in the slicer, I have to choose either the date field from the closure table or from the funding table and then the results are filtered based off of that. For instance, if I filter off of the date field from the closure table and select July 2018, the funding month will show results from July 2018 and August 2018 because the data is just filtered on loans that have a close date in July 2018.
Hi dplank
It is better for analysis if I know more details, such as the relationship between two tables, dataset structure, ect.
Best Regards
Maggie
I was able to find a solution already. I created a date table and used that date column as my slicer and then created a measure taking the max of that date and used that measure in my formulas for the closing and funding columns.
