Forum Discussion
DAX Reorder
Hi,
Reordered outlets values which were mentioned above table are not exact values. it varies with repeated occrence of customer/outlets.
week no 1 Reordered outlets is zero because those customers are fresh. there is no point of repeated customers.
week no 2 Reordered outlets are 100 (as mentioned in table but this values can vary) i.e in week no 2 total unique no of outlets are are 140 and out of this 140 unique outles how many outlets has been repated from previous week 120 unique outlets.
week no 3 Reordered outlets are 120 (as mentioned in table but this values can vary) i.e in week no 3 total unique no of outlets are are 180 and out of this 180 unique outles how many outlets has been repated from previous week 140 unique outlets
week no 4 Reordered outlets are 160 (as mentioned in table but this values can vary) i.e in week no 4 total unique no of outlets are are 205 and out of this 205 unique outles how many outlets has been repated from previous week 180 unique outlets.
Reordered rate is (current week Reordered outelets / previous week no of unique outlets) * 100
can anyone help me in writing dax for Reordered outlets and Reordered rate.
Thanks
Anonymous , this file can help you deal with last week using Rank. But for other calculations we need sample data
https://www.dropbox.com/s/d9898a48e76wmvl/sales_analytics_weekWise.pbix?dl=0
Can you share sample data.