Forum Discussion
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.
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.
I actually came with the below solution:
Created a new column with the below expression then sorted it by Month.