Forum Discussion

ashshiv_123's avatar
ashshiv_123
Helper I
3 years ago

please provide solution for below error

 
ashshiv_123's avatar
ashshiv_123
Helper I
3 years ago

Thanks for your feedback.

Please give solution for second quarter formula error also.

i have to use both simultaneously. so will be able to try this solution only after getting solution for both.

Thanks 

Ashshin_123

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