topic Re: DATE DIFF Measure in DAX Commands and Tips

DATE DIFF Measure

anwargabr — Wed, 01 Feb 2023 20:15:30 GMT

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,

Re: DATE DIFF Measure

Anonymous — Thu, 02 Feb 2023 05:29:21 GMT

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.

Re: DATE DIFF Measure

anwargabr — Thu, 02 Feb 2023 12:05:13 GMT

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

Re: DATE DIFF Measure

Anonymous — Fri, 03 Feb 2023 00:59:26 GMT

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.

Re: DATE DIFF Measure

anwargabr — Wed, 08 Feb 2023 06:42:07 GMT

Thanks and much apperciated