Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All
I have below Inventory table .
Last_sold.....Model
23/1/2019.....KL1184
23/1/2018.....KL1181
23/1/2017.....KL1182
23/1/2016.....KL1183
I like to Flag those slow moving Model more then 3 year.
Can some one share the expression .
Paul
Solved! Go to Solution.
@Paulyeo11 , A new column like
if([Last_sold] < date(year(today())-3,month(today()),day(today())), "Yes", "No")
@Paulyeo11 , A new column like
if([Last_sold] < date(year(today())-3,month(today()),day(today())), "Yes", "No")
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |