Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |