Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Month Measure

Hi Guys,   I have a doubt regarding one of my column.  I have a column "Booked Date" in my report and i have no. of deals against the booked date.   Can i break the booked date into months?    ...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi Anonymous ,

    If you are using Direct Query mode, you can create a column like this to define month name:

    Month =
VAR _m =
    MONTH ( 'Date_ID'[BookedDate] )
RETURN
    SWITCH (
        TRUE (),
        _m = 1, "Jan",
        _m = 2, "Feb",
        _m = 3, "Mar",
        _m = 4, "Apr",
        _m = 5, "May",
        _m = 6, "Jun",
        _m = 7, "Jul",
        _m = 8, "Aug",
        _m = 9, "Sep",
        _m = 10, "Oct",
        _m = 11, "Nov",
        _m = 12, "Dec"
    )

    Put this column and [ID] column in the table visual, change the aggreation of [ID] as 'SUM' and rename for this visual:

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.