Forum Discussion
Reorder dax calculation
Community Supporthi Anonymous
For your case, you need to keep the Calendar table has no relationship with Sales table or the relationship is inactive.
And if you still have the problem, please share some sample data and your expected output.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Regards,
Lin
sample data and expected output.
Date customer/outlet SKU
22/12/2019 2 A
23/12/2019 1 A
24/12/2019 3 B
25/12/2019 2 A
26/12/2019 3 C
27/12/2019 4 A
28/12/2019 8 B
29/12/2019 1 C
30/12/2019 2 A
31/12/2019 3 B
1/1/2020 1 A
2/1/2020 4 B
3/1/2020 2 B
4/1/2020 2 A
5/1/2020 3 C
6/1/2020 3 A
7/1/2020 1 A
8/1/2020 2 C
9/1/2020 3 A
10/1/2020 1 A
when slicer is between 1/1/2019 to 7/1/2019
Initial customer/outlets for A (i.e. before 1/1/2019) is 11
Repeated outlets which are in 11 are 7
Reorder value will be 11/7 = 1.58
Thanks