For top and bottom 5, instead of sets, easy way is to calc field, index
@tinaradosevich87724 жыл бұрын
Fantastic!!! Is Luke's dashboard available on Table public? I couldn't find it. I'm interested in the KPI section. Thanks!!
@xiearsene45074 жыл бұрын
Awesome! I'm not saying it's magic but it's magic. One question: at 49:41 I think that the lower bound of "Prior" should be: DATETRUNC("month",DATEADD("month",-1,[Reporting End]))
@surajkumarmehta11174 жыл бұрын
Superb Job both of you !! Question @ 49:40 regarding Prior month. Say...if the current month is Nov 2019 (last day of month= 11/30/2019) , below calculation will not include last day of Oct 2019 i.e. 10/31/2019 in Prior month. [Order Date] = DATETRUNC('month',DATEADD("month",-1,[Reporting End])) and DAY([Order Date])
@leekamar68054 жыл бұрын
Brilliant work gentlemen!! Is the workbook available on the Public forum? I am not able to find it. Thanks again for a job well done.
@PatrickBateman124204 жыл бұрын
@Jacob Metzger thanks a lot!
@haroldorel61334 жыл бұрын
Fantastic information. These guys rock. @ScarletVizion
@IrisSunCoq3 жыл бұрын
Is there any chance to download the workbook of this?