create a measure to extract Quarter and year

[Rehab_hassan]

hello team,

I need to create a measure (not a coloumn) as I am getting my data from a services data analysis services and i caanot create coloumns.

A measure should extract quarter from the (created on) coloumn in the pic attached and another measure to extract the year as well.

any help is more than apperciated.

[MFelix · Accepted solution]

Hi @Rehab_hassan ,

You need to create something like this:

Month = MONTH(MAX(Opportunities[Created On])))



Quarter =
SWITCH (
    TRUE ();
    MONTH ( MAX ( Opportunities[Created On])) ) <= 3; "Q1";
    MONTH ( MAX ( Opportunities[Created On]) ) ) <= 6; "Q2";
    MONTH ( MAX ( Opportunities[Created On])) ) <= 9; "Q3";
    "Q4"
)

Regards,

MFelix