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.
Hi Team,
I have to create a slicer filter with date column intervals, colunm name current_end_date in my table
if (interval([Current End Date] - today(), 'd') < 0, 'expired',
if (interval([Current End Date] - today(), 'd') > 0 and interval([Current End Date] - today(), 'd') < 30, 'less than 30 days',
if (interval([Current End Date] - today(), 'd') > 31 and interval([Current End Date] - today(), 'd') < 60 , 'less than 60 days',
if (interval([Current End Date] - today(), 'd') > 61 and interval([Current End Date] - today(), 'd') < 90 , 'less than 90 days',
'more than 90 days'))))
like this kind of calculations. So the Slicer should display 5 options like above image.
Please help me on this.
Solved! Go to Solution.
Hi @Nimmi,
You can add a column and try this formula.
Column = VAR interval = DATEDIFF ( [Current End Date], TODAY (), DAY ) RETURN SWITCH ( TRUE (), interval < 0, "expired", interval > 0 && interval < 30, "less than 30 days", interval > 31 && interval < 60, "less than 60 days", interval > 61 && interval < 90, "less than 90 days", "more than 90 days" )
Best Regards,
Hi @Nimmi,
You can add a column and try this formula.
Column = VAR interval = DATEDIFF ( [Current End Date], TODAY (), DAY ) RETURN SWITCH ( TRUE (), interval < 0, "expired", interval > 0 && interval < 30, "less than 30 days", interval > 31 && interval < 60, "less than 60 days", interval > 61 && interval < 90, "less than 90 days", "more than 90 days" )
Best Regards,
Create a new calculated column with "IF" statement and use the same formula you mentioned below.
Hope that resolve your query.
Regards,
Shakeel
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 |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |