Forum Discussion

3 Replies

  • dexterz's avatar
    dexterz
    Helper II
    9 years ago

    i like dax,dax is sample.

     

    Date =ADDCOLUMNS (

        CALENDAR ( "2010-01-01", "2014-12-31" ),

        "Year", FORMAT ( [Date], "YYYY" ),

        "Quarter", "Q" & FORMAT ( [Date], "Q" ),

        "MonthNum", FORMAT ( [Date], "MM" ),

        "Month", FORMAT ( [Date], "MMM" ),

        "Weekday", FORMAT ( [Date], "ddd" ),

        "WeekdayNum", WEEKDAY ( [Date], 2 ),

        "Day", FORMAT ( [Date], "dd" ),

        "Cal Month", FORMAT ( [Date], "YYYY-MM" ),

        "Cal Quarter", FORMAT ( [Date], "YYYY" ) & "-Q"

            & FORMAT ( [Date], "Q" ))

    • ovetteabejuela's avatar
      ovetteabejuela
      Impactful Individual
      9 years ago

      well, I like both and I agree  wit dexterz that DAX is simpler but I also like to implement this Dim via Power Query so it's processed at design time not on live data..

       

      Another but... I also like to implement in M the bahaviour of Calendar() function wherein you can specify the start and end date.

       

      I'm torn but I think for now I will go with DAX just because it's easy for me to implement... but long term for me is M.

       

      I just maybe need some help implementing it in M, trying to read through the link shared by MFelix