Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello All - I have a query which is a use case for me in Power BI.
I have a table in excel that I update each month with Employee Name for the division. The list would be for 1300 unique people. Based on that table, we extrapolate the same as 1300 rows for the rest of the year so that we can HC forecast for full year. In next month, we would take the HC for the end of that month and then follow the same process. For Eg, if July HC is 1300, Full Year data for each month would be updated. Next month if the HC is 1200, then July would be 1300, August would be 1200 and then September to June would be 1200 for indicative budgets. To achieve that, I need to paste 1200 records for each month. Is there a way to just paste the data for that 1 month and then thru some calculations / DAX, forecast based on the previous month.
Solved! Go to Solution.
To achieve this in Power BI, you can use DAX (Data Analysis Expressions) to create calculated columns and measures that will help you forecast the headcount (HC) for the rest of the year based on the most recent month's data.
You can create DAX measures to forecast the HC for future months based on the latest available data. Here's a step-by-step guide:
Create Relationships:
Visualize the Data:
@Yashraj just follow this steps and it will work.
Please accept this as a soultion once are done with it.
Here you... Left side is the data table in PBI, Right 3 columns are how the dat should look like. For the month when I update the data, it should consider same count for the rest of the financial year
Above is the output I have done with sample data in power BI. is this way you are looking for?
IF so I can share the screenshot of it how I did it.
To achieve this in Power BI, you can use DAX (Data Analysis Expressions) to create calculated columns and measures that will help you forecast the headcount (HC) for the rest of the year based on the most recent month's data.
You can create DAX measures to forecast the HC for future months based on the latest available data. Here's a step-by-step guide:
Create Relationships:
Visualize the Data:
@Yashraj just follow this steps and it will work.
Please accept this as a soultion once are done with it.
Hi Yashraj,
this you can do it by Dax query in power BI.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
15 | |
14 | |
13 | |
12 | |
11 |