Budget Monthly 1/No. of Days in a Month

DAX DAX Calculations
1

Problem: Allocate Monthly Budget Basically - *Monthly Budget (1/(No. of Days in a Month)
DAX Code:
DAYS IN MONTH = CALCULATE(COUNTROWS(Dates),ALLEXCEPT(Dates,Dates[Month]))
Im not getting below desired result.

A mockup of the results you want to achieve
Jan - 31
Feb - 30
Mar - 31

2

Hi @Rohit1,

I suspect the result you are getting is the count of all days that belong to a given month not restricted by a calendar year. If so use an attribute that does include years like: Dates[Month & Year]

For example:

Days in Month = 
CALCULATE( 
    COUNTROWS( Dates ), 
    ALL( Dates[Date] ), 
    VALUES( Dates[Month & Year] )
)

I hope this is helpful.

3

Thanks. It is clear.

Now

I have Monthly Budget , but it is appearing only on 1st Day of each month when i select Daily Sales. It should appear on all days for me to divide by above result.

4

Hi @Rohit1

fyi…February has 28 or 29 days (leap years) in a month not 30

thanks
Keith

5

You will find an abundance of content on that within the portal.

As your initial question has been answered, please mark that post as solution to this thread via the 3 dots. You can always create a new topic, should you require further assitance down the line.

All the best.

6

Hi @Melissa and @Keith, Thank you for always providing this group with great solutions. We greatly appreciate your efforts and your share of knowledge :slight_smile:

Hello @Rohit1, we hope these answers helped you.

If not, how far did you get and what kind of help you need further?

If yes, kindly mark as solution the answer that solved your query.

7

Hello @Rohit1, it’s been a while since we got an response from you. In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.