Forum Discussion

dplank's avatar
dplank
Frequent Visitor
8 years ago
Solved

Using 2 Date Fields as One Slicer

I have the data below. Currently the data is in 2 tables and 2 slicers for each table. If I add these fields to one table now and filter by closing month is August 2018, not all of the August 2018 fu...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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"

    NameUnitsDateCategory
    XXX8/10/2018Closure

     

    2. FundingTable : Rename the Funding date to "Date" and add new column "Category" with values "Funding"

     

    NameUnitsDateCategory
    YYY8/20/2018Funding

     

    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

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

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

dplank's avatar
dplank
Frequent Visitor
8 years ago

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.