Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
Hi @CalgaryYYC
Measure =
CALCULATE(
COUNTROWS( 'Date' ),
ALLSELECTED( 'Date'[YearMonth] )
) * 150
Let me know if you have any questions.
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.
Thank you!
Hi @CalgaryYYC
Measure =
CALCULATE(
COUNTROWS( 'Date' ),
ALLSELECTED( 'Date'[YearMonth] )
) * 150
Let me know if you have any questions.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
27 | |
23 | |
15 | |
11 |
User | Count |
---|---|
76 | |
58 | |
46 | |
17 | |
12 |