I am trying to create my own forecast because it is based on a planning.
To do this I have a few measures and some data to go with it.
Measure to determine the price of the hours in a certain month:
What is your cumulative formula? As you are shared data with month, I doubt if the same month has been used. Not the month number or Month Year(YYYYMM) or date . Because in that it might do text sorting for cumulative.
@amitchandakI am not quite sure what you are asking.
But I shared all the measure in the post so I hope you can find what you need there.
I will also add a screenshot of my Calendar Table, maybe that answers some questions.
If it doesn't please let me know.
Hi @Anonymous ,
Drag the column PowerBI_Calendar[Datum] to the table visual to see if it shows correctly?
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Watch Session 24 of Ted's Dev Camp along with past sessions!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.