topic Re: DAX Formula in Developer

DAX Formula

DianeUmu — Tue, 19 Dec 2023 16:03:57 GMT

Hello,

I'm using the above DAX to get selected month values and same period last year value of the selected date and I want now to calculate the difference between the 2. Below is the result from above DAX.

I need to calculate difference between the two dates, 11/30/2023 being selected date and 11/22/2022 being start date.

Re: DAX Formula

Anonymous — Wed, 20 Dec 2023 07:39:29 GMT

Hi DianeUmu ,

You can try the following Dax.

Test = var _mindate= IF( [SMRR Gain]=BLANK(),BLANK(), MINX(FILTER(ALLSELECTED('vm_fct_store_month_360'),[SMRR Gain]<>BLANK()),[LAST_CALENDAR_DATE])) var _maxdate= IF( [SMRR Gain]=BLANK(),BLANK(), MAXX(FILTER(ALLSELECTED('vm_fct_store_month_360'),[SMRR Gain]<>BLANK()),[LAST_CALENDAR_DATE])) return SUMX( FILTER(ALLSELECTED('vm_fct_store_month_360'),'vm_fct_store_month_360'[LAST_CALENDAR_DATE]=_mindate),[SMRR Gain]) - SUMX( FILTER(ALLSELECTED('vm_fct_store_month_360'),'vm_fct_store_month_360'[LAST_CALENDAR_DATE]=_maxdate),[SMRR Gain])

Best Regards,

Liu Yang

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

Re: DAX Formula

DianeUmu — Wed, 17 Jan 2024 16:55:27 GMT

Liu, The formula worked, However I want to have the difference between the two dates in the same measure and the output should look like this

Basically have differenece value next to 11/30/2023.
Please advice.

Re: DAX Formula

DianeUmu — Wed, 17 Jan 2024 17:02:26 GMT

And using the formula that you provided, It's giving me the same amount for the 2 dates without the difference.