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