Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DAX Reorder

Hi,                                                                             i have to write the measure for Reordered outlets i.e.                                                           ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI v-gizhi-msft                                                                                                                                                                                             

The Reordered outlets doesnt have to show the exact values as 100, 120, 160. it varies with the repeated occrence. could you please tell me why did you do - 20 in above dax 

                             

  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 205and out of this 205 unique outles how many outlets has been repated from previous week 180 unique outlets.

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

I reviewed your logic and test as below:

pbix 

Hope this helps.

 

Best Regards,

Giotto

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-gizhi-msft ,

     

    could you please review the logic agian. my logic is as given below.

    i want to count the no of unique outlets repeating stores based on current week to previous week. i.e the current week no of unique outlets that are repeated from previous week.

     

    Thanks