Hi Guys,
I have a question regarding PowerBI. To be honest, I am quite a newbie, build 1 or 2 less complicated dashboards etc but still hitting wall quite often when something new appears.
For most of you guys I assume the below issue will be easy, although for me it is road blocker. The below table represents FTEs (HR data) for given point of time.
The problem is that only first month (30.11.2020) present entire sum of FTE's of all employees. Next months presents only changes (+1 or -1 FTE).
So for example if I make a chart of current data I would receive 800FTEs in Nov'20, however only 1 FTE in Dec'20 which is not true because it should be 801FTEs.
I would like to create a formula which would make something similar to Excel Running Total In (Pivot functions) which would sum up the FTE changes per reporting date however the base value would be coming from Nov'20.
I found a Running Total option in Quick Measures in PowerBI but each time I provide details to it a receive completely erroneus data or what worse (same FTE value) for each months.
Will there be someone willing to help me?
Thank you in advance!
I have a question regarding PowerBI. To be honest, I am quite a newbie, build 1 or 2 less complicated dashboards etc but still hitting wall quite often when something new appears.
For most of you guys I assume the below issue will be easy, although for me it is road blocker. The below table represents FTEs (HR data) for given point of time.
The problem is that only first month (30.11.2020) present entire sum of FTE's of all employees. Next months presents only changes (+1 or -1 FTE).
So for example if I make a chart of current data I would receive 800FTEs in Nov'20, however only 1 FTE in Dec'20 which is not true because it should be 801FTEs.
I would like to create a formula which would make something similar to Excel Running Total In (Pivot functions) which would sum up the FTE changes per reporting date however the base value would be coming from Nov'20.
I found a Running Total option in Quick Measures in PowerBI but each time I provide details to it a receive completely erroneus data or what worse (same FTE value) for each months.
Will there be someone willing to help me?
Thank you in advance!
