topic Running Value for each column based on the previous column Value in DAX Commands and Tips

Running Value for each column based on the previous column Value

komaragiri — Thu, 25 Sep 2025 22:04:20 GMT

My data source is EXCEL. read the excel data source and create a simple Dashboard in BI.

Test data attached. appreciate your help.

Re: Running Value for each column based on the previous column Value

lbendlin — Thu, 25 Sep 2025 23:54:08 GMT

Re: Running Value for each column based on the previous column Value

komaragiri — Fri, 26 Sep 2025 01:10:12 GMT

lbendlin Thank you for ur help.

Re: Running Value for each column based on the previous column Value

komaragiri — Fri, 26 Sep 2025 04:13:20 GMT

lbendlin Instead of DAX for dailyremaing calc, can I create that column during the Transformation step?

Re: Running Value for each column based on the previous column Value

lbendlin — Sat, 27 Sep 2025 20:55:42 GMT

let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("TZA7DkMhDATvQo308A9MnxOkRRSvyA1yf8WQ2KHZYpZFA2Okx/1+pZyesALTzCPphf3CgmIImC0r78Koc23Nslt+C4pB6Zblh9kxIxxYHGMrB1bHBHrgkCE5T0MJmfNuAMdCe+PuEPKEdZlmIfXub0Swuwqxq7FTXF0T/414NWasa0cZTGbODw==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t, Column3 = _t]), #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]), #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Date", type date}, {"R1", Int64.Type}, {"R2", Int64.Type}}), #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", (k)=> let t = Table.SelectRows(#"Changed Type",each [Date]<=k[Date]) in 13749 - List.Sum(t[R1]) - List.Sum(t[R2]) ,Int64.Type) in #"Added Custom"

How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done". Once you examined the code, replace the entire Source step with your own source.