The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I am trying to create a calculated Column that provides me with the daily end balance for that day as shown below but struggling with the dax that would do something like this any ideas are much appreciated, thanks.
Date | Transaction | Balance After each transaction | Index |
1st Aug | -50 | 500 | 1 |
1st Aug | -20 | 480 | 2 |
1st Aug | -60 | 420 | 3 |
3rd Aug | -60 | 360 | 4 |
6rd Aug | -100 | 260 | 5 |
Date | Transaction | Balance After each transaction | Index | Daily Balance |
1st Aug | -50 | 500 | 1 | |
1st Aug | -20 | 480 | 2 | |
1st Aug | -60 | 420 | 3 | 420 |
3rd Aug | -60 | 360 | 4 | 360 |
6rd Aug | -100 | 260 | 5 | 260 |
Solved! Go to Solution.
@Jnickson49 Try:
Daily Balance Column =
VAR __Date = [Date]
VAR __Index = [Index]
VAR __MaxIndex = MAXX(FILTER('Table',[Date] = __Date),[Index])
RETURN
IF(__Index = __MaxIndex, [Balance After each transaction],BLANK())
@Jnickson49 Try:
Daily Balance Column =
VAR __Date = [Date]
VAR __Index = [Index]
VAR __MaxIndex = MAXX(FILTER('Table',[Date] = __Date),[Index])
RETURN
IF(__Index = __MaxIndex, [Balance After each transaction],BLANK())
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
246 | |
119 | |
114 | |
87 | |
70 |