Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculated groups DAX error

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

Help required
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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