Dynamic Measures

[Anonymous]

Hello All,
I am new to PowerBI. 
I want to create a measure that can give me data based on the current month's data.

For example: If I have the Current Month i.e. November with value = 1000

So I want to have a Projection value based on the calculation which is  = ((November Value /Days elapsed in November)*Total Number of Days in November)

If we take current date as 3rd November then Formula would be - (1000/3)*30 = 10000
It should be a dynamic formula for every month with 28,30 and 31 days with respect to each month.

Kindly help me out.

Regards,
AJP

[ryan_mayu]

could you pls provide some sample data?

[Anonymous]

Hello @ryan_mayu 
I have given a sample set as asked by you.
I want to automate the Projection using DAX. Here, the Formula for November Projection is : 

(Current Month Revenue)/(No. of Days elapsed in the current month) * (Total No. of days in the current Months)

For our case, it would be - 3000/3*30 = 30000

Date	Company	Revenue
31-07-2022	Company_1	1000
31-08-2022	Company_1	2000
30-09-2022	Company_1	2000
31-10-2022	Company_1	2500
03-11-2022	Company_1	3000
November Projection	Company_1	30000

So, what will be the DAX for the Projection of the current month?

Regards,
Aditya

[Anonymous]

Hello @Ashish_Mathur and @ryan_mayu ,
Thank you so much for your time and effort. Unfortunately, I am not able to populate the data using the formula given by you guys.
I have curated the DAX as per my tables, but when I am using the measure in any chart it gives blank values. 
Do you have any clue why that might be happening?
Kindly help.

Regards,
AJP

[ryan_mayu]

pls share your pbix file

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[ryan_mayu]

@Anonymous 

maybe you can try this to create a measure

Measure = 
VAR _date=maxx(FILTER('Table',year('Table'[Date])=year(today())&&month('Table'[Date])=month(today())),'Table'[Date])
VAR _value=maxx(FILTER('Table','Table'[Date]=_date),'Table'[Revenue])
return _value/day(_date)*day(EOMONTH(_date,0))