topic Re: Calculated groups DAX error in DAX Commands and Tips

Calculated groups DAX error

Anonymous — Mon, 14 Feb 2022 10:56:55 GMT

Hello - can anyone tell me why this DAX is not working when i use to try and create a calculation group...? Thanks in advance!

VAR date =
MAX ( BO_data[Reference_Date] )
VAR LastDec =
DATE ( YEAR ( ( date ) - 1 ), MONTH ( 12 ), DAY ( date ) )
VAR RESULT =
CALCULATE (
SELECTEDMEASURE (),
FILTER ( 'Calendar', 'Calendar'[Date] <= LastDec )
)
RETURN
RESULT

Re: Calculated groups DAX error

amitchandak — Mon, 14 Feb 2022 11:19:28 GMT

Anonymous , try like

VAR _date =
MAXX (allselcted( BO_data), BO_data[Reference_Date] )
VAR LastDec = DATE ( YEAR ( ( _date ) - 1 ), 12 , DAY ( _date ) )
VAR RESULT =
CALCULATE (
SELECTEDMEASURE (),
FILTER (all( 'Calendar'), 'Calendar'[Date] <= LastDec )
)
RETURN
RESULT

if needed remove all from calendar