Forum Discussion

ashshiv_123's avatar
ashshiv_123
Helper I
3 years ago

please provide solution for below error

 
nandukrishnavs's avatar
nandukrishnavs
Community Champion
3 years ago

ashshiv_123 

 

Quarter =
VAR _monthno =
    MONTH ( 'Date'[Date] )
VAR _result =
    SWITCH (
        TRUE (),
        _monthno <= 3 = "Q3",
            _monthno <= 6 = "Q4",
        _monthno <= 9 = "Q1", "Q2"
    )
RETURN
    _result
ashshiv_123's avatar
ashshiv_123
Helper I
3 years ago

Thanks for your quick response.

 

But i want to know what is wrong in my above dax quarter function? system is giving error. i want to rectify said error please. if you are able to let me know issue with above formula, it will be of great help for me.

 

Thanks & Regards,

 

Ashshiv_123