Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Dear all,
please find enclose an example for a PBI Report incl. a VDIM_Calendar and a vfakt table.
In the xls file, I have highlighted in light blue the basic information that is available to me according to vfakt. The orange columns I have added in the vfakt by calculation. Now I am missing the information of the green fields in the Power Bi Report.
In the end, in the PBI report, I need a stacking column graph that stacks the budget monthly values of each project.
The monthly values are always assigned to the last day of the month, i.e. in the start date is the start month and the year, the runtime is the number of months related to the runtime (years). The end date contains the last month at the end of the runtime (months).
Maybe it will be easier to understand if you look at the report and the Excel sheet with the result.
Thank you for your help in advance!
KR
Maha
I hope I can share the pbi file and the xls file with these links.
PBI File
xls File with solution in Excel
https://app.powerbi.com/groups/me/workbooks/1_69169_3000654?experience=power-bi
PBI screenshot VFAKT and calendar VDIM
Excel screenshot
Solved! Go to Solution.
Based on what I got the following video will be helpful -
Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
Video helps very good, just made some modifications. Thank you!
Video helps very good, just made some modifications. Thank you!
Based on what I got the following video will be helpful -
Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
User | Count |
---|---|
65 | |
46 | |
20 | |
18 | |
15 |
User | Count |
---|---|
119 | |
41 | |
40 | |
28 | |
22 |