I have a Leavers list in Table having their Month of Leaving and Month of Joining.
* My Date table is linked to Month of Leaving.
I want a monthly trend / Running Total showing Sum of Leavers (who left in last 3 months and their month of joining is also in the last 3 months).
I am quite new to Power BI, can someone help me with the solution please?
Go to Solution.
Based on my test, you could refer to below steps:
Create a date table and create relationship:
Date = CALENDARAUTO()
Create below calculated columns:
a = CALCULATE (
SUM ( Table1[joiners]),
b = CALCULATE (
SUM ( Table1[Leavers]),
View solution in original post
Could you please offer some sample data to have a test or post your data picture if possible?
Please find the sample, thanks in advance for help:
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.