Forum Discussion
Dynamic Measures
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 ...
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
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))