Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I have sales data which has two date columns (let's call them date1 and date2). I would like to only show data where the year of these columns match -> example: if date1 = 1.12.2019 and date2 = 1.1.2020 -> exclude row.
Can you help me finalize this?
Solved! Go to Solution.
IF(YEAR([Date1]) = YEAR([Date2]),1,BLANK())
IF(YEAR([Date1]) = YEAR([Date2]),1,BLANK())
User | Count |
---|---|
57 | |
21 | |
19 | |
19 | |
16 |
User | Count |
---|---|
85 | |
80 | |
52 | |
37 | |
22 |