Forum Discussion
Need help in DAX
Hi,
I have below table. I don't have Previous Day column and wanted create Total Value column as per the below table. Is it possible to get that. The first date in a month I wanted to pass as zero for Previous day value. And the same should applies if I have multiple Sr No's (Product Line, Product Line 2 and so on....
Any help in DAX?
| Sr No | Date | A | B | C | Previous Day Value | Total Value |
| Product Line 1 | 01-Jan-24 | 20 | 30 | 40 | 0 | 20+30+40+0 (This zero value is default at the starting day of a month . So total value should be 90 |
| Product Line 1 | 02-Jan-24 | 13 | 43 | 5 | 13+43+5+90 (This 90 value is nothing but previous day). So total value should have 151 | |
| Product Line 1 | 03-Jan-24 | 18 | 30 | 22 | 18+30+22+151 (This 151 value is nothing but previous day value. So total value should be 221 |
11 Replies
Unpivot your A, B and C columns to bring them into a usable format. Then use a "Running Total" Quick measure.
Create a calculated column that adds up A, B and C. Create a running total quick measure over that column
