Is it possible to do different calculation on a measure depending on Month

[justnoob08]

Hello Guys, I have been struggling on how I can do this. 

Below is what I'm trying to achieve to display on a matrix Visual. 

WeightScore = [Score] * 0.05 (For Jan - March)

WeightScore = [Score] * 0.03 (For April- June)

So basically, the percentage changes depending on the quarter but It needs to be displayed on a single measure. I tried using If, but unable to achieve this.

Thank you for the help!

	Score	Weight Score
January	5	0.25
February	5	0.25
March	5	0.25
April	5	0.15
May	5	0.15
June	5	0.15
July	5	0.4
August	5	0.4
September	5	0.4
October	5	0.5
November	5	0.5
December	5	0.5

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[justnoob08]

Thank you! this is really helpful!

[Ashish_Mathur]

You are welcome.

[amitchandak]

@justnoob08 , Create a new measure like

[Score] * Switch(True(),
[month] in {"January","February","March"}, 0.05,
[month] in {"April","May","June"}, 0.05,
// Add other
)

[justnoob08]

Hi, amitchandak. Thank you for the response, I have a problem I can't seem to use month because it is a column on my calendar table. I'm I doing something wrong here?