Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I need output from my table like mentioned in the image. Kindly help me to get the solution.
Solved! Go to Solution.
hi,
try creating 3 calculate column.
30 days=if(datediff(today();I-94 Valid To;DAY)>30&&datediff(today();I-94 Valid To;DAY)<=180;1;0)
180 days=if(datediff(today();I-94 Valid To;DAY)>180&&datediff(today();I-94 Valid To;DAY)<=230;1;0)
230days=if(datediff(today();I-94 Valid To;day)>230;1;0)
I don't know the structure of your table, but this can give you an idea of what to do.
hi,
try creating 3 calculate column.
30 days=if(datediff(today();I-94 Valid To;DAY)>30&&datediff(today();I-94 Valid To;DAY)<=180;1;0)
180 days=if(datediff(today();I-94 Valid To;DAY)>180&&datediff(today();I-94 Valid To;DAY)<=230;1;0)
230days=if(datediff(today();I-94 Valid To;day)>230;1;0)
I don't know the structure of your table, but this can give you an idea of what to do.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |