Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric certified for FREE! Don't miss your chance! Learn more

Reply
CSA1
Frequent Visitor

DAX query for a Case statement

Hi , I am new in PowerBI, Can somebody please help me to create a DAX for the following Case statement,

 

Thanks,

 

Case when Year(SOLINE.[Deliv Date]) < Year(getdate()) then 'CurrentPeriod'
when Year(SOLINE.[Deliv Date]) = Year(getdate()) and month(SOLINE.[Deliv Date]) <= month(getdate()) then 'CurrentPeriod'
when Year(SOLINE.[Deliv Date]) = Year(getdate()) and month(SOLINE.[Deliv Date]) = month(getdate()) +1 then 'CurrentPeriod_1'
when Year(SOLINE.[Deliv Date]) = Year(getdate()) and month(SOLINE.[Deliv Date]) = month(getdate()) +2 then 'CurrentPeriod_2'
when Year(SOLINE.[Deliv Date]) = Year(getdate()) and month(SOLINE.[Deliv Date]) = month(getdate()) +3 then 'CurrentPeriod_3'
when Year(SOLINE.[Deliv Date]) = Year(getdate()) and month(SOLINE.[Deliv Date]) > month(getdate()) +3 then 'Forward' End SODeliveryPeriod

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @CSA1 ,

 

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.

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @CSA1 ,

 

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.

 

lbendlin
Super User
Super User

The DAX equivalent is SWITCH(TRUE(),...,...)

Helpful resources

Announcements
Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.