Forum Discussion
Visual date sorting (Blank) to other end
Super Userjameshoneywill , if these is blank in you table, it should be give a highest number on sorting (in sort column )
example
if(isblank([Month Year]), 9999999, year([Date])*100 + month([Date]) )
Use this as sort column
If there is no blank, means either date table is missing dates (seems like the case here)
or fact is missing dates on the join column
Hi amitchandak
Yes, the fact table is missing dates (the field is an expected delivery date which is unknown so will be blank where this is the case - I don't want to replace bank with a phantom date, I do want it to show as blank)
Currently, in the date table I am sorting based on "MonthOffset" (e.g. October 2022 = -1) so that the months order correctly.
Are you saying I should create a custom column in the date table? so the negative result is "MonthOffset" and the positive as, for example +99999)
Will this work even if the date table doesnt have a blank?