SQL alias conversion in LookML

We have only one date column in database but two different references (alias in SQL) need to be made out of them (current and previous) to proceed further and compare as per requirement. How to achieve this LookML?

And how to deal with date field with NULL value in it?

Date
4/01/2020
7/01/2020
10/01/2020
1/01/2021
1 0 148
0 REPLIES 0
Top Labels in this Space
Top Solution Authors