Showing Expiry date of items using number of days parameters

[shabirAhmad]

Dear Experts,

We have item and expiry date. i want to add parameters of number of days. As i enter 30 in days parameter it shows those items which will be expire within in 30 days. As i enter 60 days it will shows those items expire withing 60 days etc. It is kind of aging report but reverse to aging. Aging report showing past this report should show only future expiry items.Please support.

Note: Expiry date field is already in the table, so the report will be filtered from number Days parameter and then number of days will check the expiry date field and show data as per perameter.

Best Regards,

Shabir Ahmad

[shabirAhmad]

Hi @Idrissshatila ,

Thanks for your prompt reply, i colored these field in image shown above. check in parameters. It shows two 2 fields as i want only 1 field as slicer, which will filter data for this report.

Best Regards,

Shabir Ahmad

[Idrissshatila]

Hello @shabirAhmad ,

so is there anything else I could help you with ?

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[shabirAhmad]

@Idrissshatila ,

Thanks clear me only one thing as i posted a query, why 2 fields are showing as a slicer, i need only 1 field which will filter the report.

Best Regards,

Shabir Ahmad

[Idrissshatila · Accepted solution]

Hello @shabirAhmad ,

You could change the slicer settings from the visualisation pane into like greater than a number and it will show like this

or you could do it as drop down 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Idrissshatila]

Hello @shabirAhmad ,

So first thing you do is create a new column in the table that shows the date difference between today and expiry date. This will show the diff in days as a column. 

check the datdiff dax function https://learn.microsoft.com/en-us/dax/datediff-function-dax

Difference  = DATEDIFF ( Today(), YourTableName[ExpiryDate], Day ) 

Then after creating this field, you add it as a slicer in the report so you could filter using it.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin