DATE DIFF Measure

[anwargabr]

Dear Experts,

I need help to write DAX measure or variables calculating the DATE differnce as follows:

if "FROM" not qual to "ISSUE DATE", 

calculate the DAT FIFF in column "FROM" at any date with the previous date "Dates"

th eresult shoul be

• all "form" 30/3 should be ignored as from = issue
• DATES “1/10, 25/11, 26/11 and 28/11" diff will be ZERO
• DATES 30/9 and 27/11 will be difference.

Thanks,

[anwargabr]

Dear Polly,

Thanks for your help, actually the calculation is wrong as the results should be

I've attached the excel file for my saple data

test DATE DIFF.xlsx

[v-rongtiep-msft · Accepted solution]

Hi @anwargabr ,

Please try to change the measure.

Measure = var _1=CALCULATE(MAX('Table'[From]),FILTER(ALL('Table'),'Table'[Index]=SELECTEDVALUE('Table'[Index])-1))

return 
IF(MAX('Table'[From])=SELECTEDVALUE('Table'[issue date]),BLANK(),DATEDIFF(_1,MAX('Table'[From]),DAY))

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

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

[anwargabr]

Thanks and much apperciated

[v-rongtiep-msft]

Hi @anwargabr ,

I have created a simple sample, please refer to my pbix file to see if it helps you.

Create a measure.

Measure = var _1=CALCULATE(MAX('Table'[dates]),FILTER(ALL('Table'),'Table'[Index]=SELECTEDVALUE('Table'[Index])-1))

return 
IF(MAX('Table'[From])=SELECTEDVALUE('Table'[issue date]),BLANK(),DATEDIFF(_1,MAX('Table'[From]),DAY))

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

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