Help to clean data

[VDS9]

Hi everyone, 

I need to create a simple report on behaviour points throughout time period.

This is how we get data, what would be the best way to clean it and transform the data?

All I need to see once I buoild the reports, its if behaviour improved or not and if negative points increased or decreased throughout the time..

Help Please

Thanks.

I know its a big ask but I need to bring this report tomorrow morning into work.

[Anonymous]

Hi @VDS9 ,
According to your description, you need to process the data and show the trend after the data changes.
First, you need to classify or aggregate the data so that you can visualize the statistics of the data at various levels of granularity (type, time, etc.), which can be done technically as 0, 1, or -1. You can do this through grouping in power query, or aggregation functions in dax.
After you clean up the data and create the dax function, you can show the trend through a visual legend such as a scatterplot or line graph, and determine whether the negative score has increased or decreased throughout the time period from the density of the scatterplot.
You can refer to this document to learn how to create a scatterplot:
Scatter, bubble, and dot plot charts in Power BI - Power BI | Microsoft Learn

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly