no of days between max date and latest date from same column

[Anonymous]

Hi All,

I need to calculate no of days between max date - latest date from the same columns for each product.

details are below :

[parry2k]

@Anonymous do you have refresh date in your data model, if yes, you can use datediff function to calculate # of days.

[Anonymous]

Hi , Thanks for your response,

as mentioned - i have only one column in my data model( MYTable(date) ,max date would be my refreshdatemax(MYTable(date)) , and latest date would be latest MYTable(date).

formula would be max(MYTable(date)) - latest (MYTable(date).) we need to build this logic .

Thanks

[parry2k]

@Anonymous confusing part is your example dataset doesn't have May 20th, 2019 as latest date, as per your example dataset the latest date is May 18th, 2019.

So if I have to work on example data set, am I using May 18th, 2019 as most recent date or today's date.

Just a note, if you are providing sample data, make sure your expected result is based on that sample data, it just adds extra confusion what you want?

[Anonymous]

Thanks for your prompt response ,

and sory for confusion .

yes please use may 18th 2019.

Thanks

[parry2k]

@Anonymous isn't in that orange will have recent date = May 18th, 2019 and differnce of days will be zero? Another confusing part on your question.

[Anonymous]

here is the sample data

[parry2k · Accepted solution]

@Anonymous this make sense and here is the solution,  add following measures

Recent Date = CALCULATE( MAX( Table3[Date] ), ALLEXCEPT( Table3, Table3[Data] ) )

Latest Date = CALCULATE( MAX( Table3[Date] ), ALL() )

# of Days = DATEDIFF( [Recent Date], [Latest Date], DAY )

I believe above will meet your requirement, take some time to read this post on how to get answer quickly

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490