Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear members,
I was trying to write a custom formula to implement the following expressions in many ways but I faced errors each time can you please help me out. The expression is : IF TODAY is > 9/13/2021, then count the # of days from 9/13/2021 to TODAY , then divide that number by 7 in order to get the # of weeks .
Solved! Go to Solution.
Like this?
NumWeeks =
IF (
TODAY () > DATE ( 2021, 9, 13 ),
DATEDIFF ( DATE ( 2021, 9, 13 ), TODAY (), DAY ) / 7
)
Like this?
NumWeeks =
IF (
TODAY () > DATE ( 2021, 9, 13 ),
DATEDIFF ( DATE ( 2021, 9, 13 ), TODAY (), DAY ) / 7
)
Thanks indeed Alexis this is exactly what I was targeting I will try it out and hope it gives me the exact results.
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |