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 guys,
I'm having little trouble writing an IF statement.
Here is the logic DateReceived minus Inv Date being greater or less than 50.
This is the the function I wrote but is invalid.
Column = IF (AND(('Table1 '[DateReceived]) - [InvDate] < 51 ), "<50 Days","50+ Days ")
Can someone please help?
Solved! Go to Solution.
Hi @Stuznet
Use this.
Column = IF ( Table1[DateReceived] - Table1[InvDate] < 51 , "<50 Days","50+ Days ")
Thanks
Raj
The formula you have is invalide because you are using AND condition and only condition1 is listed. Here is how I fix it:
Column = IF ( DATEDIFF( [InvDate], [DateReceived], Day) <50 ,"<50 Days" ,"50+ Days ")
Hi @Stuznet
Use this.
Column = IF ( Table1[DateReceived] - Table1[InvDate] < 51 , "<50 Days","50+ Days ")
Thanks
Raj
@Anonymousperfect as always. 🙂
User | Count |
---|---|
95 | |
89 | |
70 | |
63 | |
58 |
User | Count |
---|---|
149 | |
113 | |
95 | |
80 | |
72 |