this is a dirty dataset i make ETL process on this data to make it clean and concise to my QA i need to answer by Power Query Editor (changing datatype, remove duplicate rows, extracting hour from Time, remove Blanks&Nulls, remove unused columns) i use DAX language to add a new measure and using in the report