Forum Discussion
Need Suggestions for a Date Range Function for Inventory - PLEASE HELP!
The table thread was helpful. The measures seem to work (Min,Max, Measure) however it does not seem to be changing the data in the actual table visualization. I noticed that there is not a relationship betwen between the two tables in the .pbix file, but don't understand why it's not changing the display.
Resident RockstarHi Anonymous,
Yes, there is no relationship for the two tables in this way.
We use measure to get the date in calendar table as you know measure is not belong to the specific table which could get the values for each table.
We should filter the measure so that the data in fact table will be filtered by the seletedvalue in between slicer. If you don't want to show the measure in your table visualization, you could put the measure to visual level filter like below and apply filter.
If you need create the relationship for the data table and the fact table, you could try another way to achieve your requirement.
You could refer to this similar thread. The way is to create the relationshio bewteen the tables. However, if your date range is very large, the performance for this methord may be not good.
Best Regards,
Cherry