I have a column called date that is currently as data type text.

I have a column called date that is currently as data type text.

I have a column called date that is currently as data type text.

I have a column called date that is currently as data type text.

I have a column called date that is currently as data type text.

I have four tables: Daily Inventory, AFPO, RESB, and EKPO.

This is a Power BI question. I would like a solution with either a DAX measure or calculated column.
I have a table:
| ID | Value | Date 1 | Date 2 | Value 2 | Result |
|:– |:—– |:—— |:—— |:——- |:——:|
| A|1000| 08/12/2024| 08/12/2024| -100| 900|
|B| 1200| 08/12/2024| 08/12/2024|-250|950|
|C| 1500| 08/12/2024| 08/12/2024| 0| 1500|
|A|1000| 08/12/2024| 08/13/2024|-300| 600|
|B| 1200| 08/12/2024| 08/14/2024| 50| 1000|
|A|1000|08/12/2024| 08/20/2024|0|600|
|C|1500|08/12/2024|08/20/2024| -500|1000|
I want to add column “Result” for dynamically calculating the sum of “Value” and “Value 2” columns based on the “Date 2″(in ascending order) and corresponding “ID” columns. “Date 1” column will always be the same day (today) but it has duplicated IDs and Values. What I need is to calculate Result [1]= Value +Value 2 but then Rusult [2] = Result [1] + Value 2 [2].

I’m having a problem trying to check for overlapping activities in a table I’m using. I found several posts similar to my situation, but I can’t solve it.

I have a deployed ML model. I am using a Flask app to use the model and return predictions. It is a Post request which input payload in this form

Based on the below table I want to calculate the difference (in days) between the current date and the previous date this Category appears in the past.