Forum Discussion
Helper IFilter date ranges based on text filter value
I had a relationship link from the Date Selector to the Date Table. Removing that made all this work.
Community SupportHi, TDisco ;
I tested it , It's all true in the cases I tested. Maybe you missed something that we didn't notice. For example, your table has other filters, and secondly, you can compare your [MM_slicer] and [mm_sum_UnplannedMinutes_last3] in a table. The external conditions all reduce the variables.
Or you could share more detail about your structure and relationships of the data, or a simple file？Looking forward your reply!
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
TDiscoLets try one more screen shot. Here is the file Google Drive (temp link)
And hey. thanks for sticking with me on this 😃
See image. No filters are present, except for what is in the measures.
- Filter is linked to Table (only this table)
- The measure to build the links and the measures placed in a table.
- I added a test_3rdmonth measure to validate the _last3 measure
- All the measures are written like this. The _last3 should equal the sum of these three measures: _current, _previous, _test_3rdmonth - which it does in the "2" table - but when used with the filter in table "1" - only returns the 3rd month value and not the last 3 month sum.
Dataset. is trimmed for just two systems.
- Column – Data Type
- System is Text
- Metric is Text
- Date is Date (All Dates are for start of every month = January 2021 – 1/1/2021)
- MetricResult is General (Not Summarized)
- v-yalanwu-msft
Hi, TDisco ;
I can't really judge from the screenshot you gave, your link needs permission to open.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- TDisco
Do you recommend another method to share the file?