Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Here is the question and answer they say is slicer: I think is is the Second one down. Can you tell me what you think?
Slicer |
IF(OR((([HireDate]-[TermDate])) >= 61,ISBLANK([TermDate])),0,1) |
IF(((([HireDate]-[TermDate])*-1) < 61),1,0) |
IF((([TermDate]-[HireDate])*-1) >= 61,0,1) |
Solved! Go to Solution.
Hi @Anonymous,
By my test, the second formula should be right based on the three formulas.
However, I think the below forumula will be better based on your requirement.
Column = IF ( OR ( DATEDIFF ( 'Table1'[HireDate], 'Table1'[Termdate], DAY ) >= 61, ISBLANK ( 'Table1'[Termdate] ) ), 0, 1 )
Hope this can help you.
Best Regards,
Cherry
Hi @Anonymous,
By my test, the second formula should be right based on the three formulas.
However, I think the below forumula will be better based on your requirement.
Column = IF ( OR ( DATEDIFF ( 'Table1'[HireDate], 'Table1'[Termdate], DAY ) >= 61, ISBLANK ( 'Table1'[Termdate] ) ), 0, 1 )
Hope this can help you.
Best Regards,
Cherry
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |