My data source is from SQL table where it has already been gathered and transform into one output table.
There is a report within SQL table whereby the script procedure will time stamp base on the specific week data is loaded.
e.g if data is loaded 25-Jun 2018, the custom time stamp format would be as text and shows as “2018.26” current Year/ Current Week column.
Would like to know what would be the recommended practice/approach to such data format in PowerBi if i were to make comparisons;
e.g. Difference of Week 26 Total Ordered Quantity against Week 25 Total Ordered Quantity and base on several parameter.
Attached test data as reference.
Test data.pbix (606.6 KB)
Thanks & Best Regards