Multiply a constant number by days in month from date table

[CalgaryYYC]

Looking for help in multiplying a single constant number by the days in the month of the year. 

example:

constant 150 

January = 31 days 

result = 150 * 31 = 4,650

next month (based on date setting) 

Constant 150 

February = 28 

Result = 150 * 28 = 4,200

thank you! 

[Anonymous]

Hi @CalgaryYYC ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please feel free to let me know.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[CalgaryYYC]

Thank you!

[gmsamborn · Accepted solution]

Hi @CalgaryYYC 

Measure =
	CALCULATE(
		COUNTROWS( 'Date' ),
		ALLSELECTED( 'Date'[YearMonth] )
	) * 150

Let me know if you have any questions.