Forum Discussion
Need Suggestions for a Date Range Function for Inventory - PLEASE HELP!
Hi Anonymous,
Please refer to this similar thread which should meet your requirement.
If you still need help, please share your desired output and your data sample.
Best regards,
Cherry
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.
Hi 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
Hi Anonymous,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry