DAX query for a Case statement

Hi Anonymous ,

Getdate() seems to be the function in SQL, we will use Now() to get current datetime in DAX.

In addition to  lbendlin 's reply, you can try this code to create a calculated column.

Period =
SWITCH (
    TRUE (),
    YEAR ( SOLINE.[Deliv Date] ) < YEAR ( NOW () ), 'CurrentPeriod',
    YEAR ( SOLINE.[Deliv Date] ) = YEAR ( NOW () )
        && MONTH ( SOLINE.[Deliv Date] ) <= MONTH ( NOW () ), 'CurrentPeriod',
    YEAR ( SOLINE.[Deliv Date] ) = YEAR ( NOW () )
        && MONTH ( SOLINE.[Deliv Date] )
            = MONTH ( NOW () ) + 1, 'CurrentPeriod_1',
    YEAR ( SOLINE.[Deliv Date] ) = YEAR ( NOW () )
        && MONTH ( SOLINE.[Deliv Date] )
            = MONTH ( NOW () ) + 2, 'CurrentPeriod_2',
    YEAR ( SOLINE.[Deliv Date] ) = YEAR ( NOW () )
        && MONTH ( SOLINE.[Deliv Date] )
            = MONTH ( NOW () ) + 3, 'CurrentPeriod_3',
    YEAR ( SOLINE.[Deliv Date] ) = YEAR ( NOW () )
        && MONTH ( SOLINE.[Deliv Date] )
            > MONTH ( NOW () ) + 3, 'Forward',
    "SODeliveryPeriod "
)

Best Regards,
Rico Zhou

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