Month Measure

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.