Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Have field called [Off Contract Date] the value is 04/28/22
I need a formula to count number of days elapsed in that particular month so answer should be 28 in the example above but this field is variable and will change, field called [PartialBillingDays]
Next would like to create a field called [PartialBilling%] formulated by dividing (28) or [PartialBillingDays] / the number of days in the month represented in [Off Contract Date] or Date.DaysinMonth([Off Contract Date])
So in this example the math would be 28 / 30 = .9333%
I can get the PartialBilling% to work but just cannot find the correct formula to cover the PartialBillingDays amount.
Solved! Go to Solution.
Use following formula for PartialBillingDays
= Date.Day([Off Contract Date])
I figured out the error I included a % in name description
I get an error message with that formula
if checked to make sure the field was set to a date type {"Off Contract Date", type date}
Any thoughts?
Can you click on the error and paste the message here?
Use following formula for PartialBillingDays
= Date.Day([Off Contract Date])