Unable to get the number of days between 2 dates in a calculated table - Need Help

[AmeenVanakar]

Hi,

I have created a table showing all the barcodes available in the warehouse but I cannot get the date difference between the purchase date (corresponding to the barcode) and today. Can you please help?

Stock_Age = DATEDIFF(SUMMARIZE(RELATEDTABLE(Warehouse_Stock),Warehouse_Stock[PURCHASE DATE]),TODAY(),DAY)

The lookup is the unique barcode that is created using the below simple formula.

 

[dharmendars007 · Accepted solution]

Hello @AmeenVanakar , 

Please try the below formula and please make sure the Puchase date is in date format.

Stock_Age = DATEDIFF(Warehouse_Stock[PURCHASE DATE], TODAY(), DAY)

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[AmeenVanakar]

Thanks @elitesmitpatel and @dharmendars007  the solution worked!

[elitesmitpatel · Accepted solution]

Hey @AmeenVanakar 
Please  make some changes in measure 

Stock_Age =

 DATEDIFF(RELATED(Warehouse_Stock[PURCHASE DATE]),TODAY(),DAY)

Stock Age Range =

SWITCH(

    TRUE(),

    'Stock Age Table'[Stock_Age]>=365, "Above 365",

    'Stock Age Table'[Stock_Age]>=181, "Above 180",

    'Stock Age Table'[Stock_Age]>=151, "151-180",

    'Stock Age Table'[Stock_Age]>=121, "121-150",

    'Stock Age Table'[Stock_Age]>=91, "91-120",

    'Stock Age Table'[Stock_Age]>61, "61-90",

    'Stock Age Table'[Stock_Age]>31, "31-60",

    "Below 0-30"

)

Please Kudos and Accept it as solution so other community member get helped
Thank You

[dharmendars007 · Accepted solution]

Hello @AmeenVanakar , 

Please try the below formula and please make sure the Puchase date is in date format.

Stock_Age = DATEDIFF(Warehouse_Stock[PURCHASE DATE], TODAY(), DAY)

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[AmeenVanakar]

Hi @dharmendars007 

No luck! It's still throwing errors. I am looking for the date difference corresponding to the unique barcodes

[elitesmitpatel]

Please share the Dummy Pbix file

[AmeenVanakar]

Hi @elitesmitpatel 

Here is the file warehouse analysis.pbix

[elitesmitpatel]

Hey @AmeenVanakar 
Here is the solution 
Just made the relationship between these two tables 

then the measure mentioned by @dharmendars007  will work and you will get the expected output

PBIX File link 
Unable-to-get-the-number-of-days-between-2-dates-in-a-calculated Solved 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[AmeenVanakar]

Thanks @elitesmitpatel 

I also noticed that you have made changes to the "Stock age range" column & it seems to be a circular reference. Any idea how to solve this? I need to use this column as a filter.