Forum Discussion
Transforming Cumulative data files
Hello guys, I need help in transforming the data based on the example I attached. I am receiving monthly data, but these data contain cumulative values for the period (no data column per month). ...
Hi,
There has to be a Date column in each table. Creae that and share data in a format that can be pasted in an MS Excel file.
This is just an example of how my data are structured. I do not have permission to change anything on the source but I can make changes in the PBI Query Editor. I already created a date table but still, these are cumulative values. I created some DAX measures but still, this is not the solution I expected
A date column will have to somehow be created for the subtraction to happen. Share data (with actual column headers) in a format that can be pasted in an MS Excel file.