topic Re: Use parameter in DAX in DAX Commands and Tips

Use parameter in DAX

Anonymous — Fri, 23 Dec 2022 22:27:32 GMT

Hi all,

I created 2 parameters, one for year(2019-2023) , one for month(1-12). And created a new measure :

Selected last date = EOMONTH(DATE('Year Parameter'[Year Parameter Value],'Month Parameter'[Month Parameter Value],1),0)

Filter to Selected Date = DATEDIFF('Shop Account Ledger'[G/L Date],EOMONTH(DATE('Year Parameter'[Year Parameter Value],'Month Parameter'[Month Parameter Value],1),0),day)

My goal is to decide if the date is before or after the G/L date. You can see the datediff is absolutly wrong, I don't know why.

I really need help.

Thank you in advance!

Merry Christmas!

Re: Use parameter in DAX

FreemanZ — Sat, 24 Dec 2022 02:19:34 GMT

hi Anonymous

try like:

Filter to Selected Date = DATEDIFF( MAX( 'Shop Account Ledger'[G/L Date]), EOMONTH(DATE('Year Parameter'[Year Parameter Value],'Month Parameter'[Month Parameter Value],1),0),day)

Re: Use parameter in DAX

Anonymous — Sun, 25 Dec 2022 06:05:04 GMT

It doesn't work.

Re: Use parameter in DAX

FreemanZ — Sun, 25 Dec 2022 06:45:48 GMT

hi Anonymous

a bit strange, this was a verified proposal:

Re: Use parameter in DAX

Anonymous — Mon, 26 Dec 2022 06:36:09 GMT

Hi Anonymous ,

Please review your model relationships and create a measure.

Filter to Selected Date = var _lastdate=EOMONTH(DATE('Year Parameter'[Year Parameter Value],'Month Parameter'[Month Parameter Value],1),0) return DATEDIFF(SELECTEDVALUE('Shop Account Ledger'[G/L Date]),_lastdate,DAY)

Then the result is as follows.

Best Regards,

Neeko Tang

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