Need Suggestions for a Date Range Function for Inventory - PLEASE HELP!

[Anonymous]

I have a dataset that includeds a Start Date and End Date for availability of my product.  Because I have two endpoints, when I use a date slicer it does not acknowledge the days between the Start and End. 

For instance a customer needs to purchase my services product between 1/1/2018 and 1/4/2018.  This represents the Start/End, but when I use a date slicer and filter to 1/2/2018 there is no result in the table making it look like I am available.

Is there a way to have the slicer account for the Start and End as a range, so that the output in the table-visualization ackowledges the dates between the two points as well?

[v-piga-msft]

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

[Anonymous]

@v-piga-msft

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.

[v-piga-msft]

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

[v-piga-msft]

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