- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

How to filter visuals correctly when using multiple dates
Hi,
I would like to know how (if possible) I can filter visuals correctly when I am using multiple dates. I will explain my situation below:
I have a date table and a sales table. These two tables are related by Date[Date] and Sales[InvoiceDate] as I usually report sales based on the invoice date and this has worked fine.
However, on the sales table there is also another date called CreationDate, I would now like to see all my sales broken down by the creation date. So what I have done is, created an inactive relationship between Date[Date] and Sales[CreationDate] and created a measure
CALCULATE(Sales[SalesTotal],
This works and I am able to use various columns from the date table (i.e. Financial Year) and see my sales according to the CreationDate - I have this displayed in a matrix.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi,
I think you will have to rewrite all the measures with the USERELATIONSHIP() function.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@HarrisonBi , When you filter months from the date table. Visual using USERELATIONSHIP('Date'[Date],Sales[CreationDate]) will filter on Creation date.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Join our Community Sticker Challenge 2025
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Subject | Author | Posted | |
---|---|---|---|
11-15-2023 07:53 AM | |||
06-10-2024 10:41 AM | |||
08-07-2023 11:43 AM | |||
06-06-2024 07:56 AM | |||
02-07-2024 06:00 AM |
User | Count |
---|---|
102 | |
68 | |
66 | |
51 | |
41 |
User | Count |
---|---|
164 | |
84 | |
68 | |
66 | |
61 |