I want to calculate the "Change of Values" for a "Products" between the today and previous day and Previous day vs a day before previous for 5 days. I have given example of two Products, however I have around 1000+. Can anyone please help with the DAX formulas for Power BI. Thanks in advance for your help.
| PRODUCTS | DATE | PREV_CLOSE | OPEN_PRICE | Chg PREV_CLOSE | Chg OPEN_PRICE |
| PENCILS | Monday, February 1, 2021 | 1124.4 | 1125 | ||
| PENS | Monday, February 1, 2021 | 243.35 | 246.4 | ||
| PENCILS | Tuesday, February 2, 2021 | 1169.75 | 1179.35 | ||
| PENS | Tuesday, February 2, 2021 | 260.8 | 263.7 | ||
| PENCILS | Friday, February 5, 2021 | 1220 | 1229.6 | ||
| PENS | Friday, February 5, 2021 | 272.75 | 273 | ||
| PENCILS | Thursday, February 4, 2021 | 1187.95 | 1193.8 | ||
| PENS | Thursday, February 4, 2021 | 268.95 | 268 | ||
| PENCILS | Wednesday, February 3, 2021 | 1149.95 | 1159 | ||
| PENS | Wednesday, February 3, 2021 | 276.25 | 276.1 |
