Forum Discussion
Naming specific dates for filtering afterwards
Hi there,
I would ike to creat a column naming specific date ranges in order to create a filter afterwards. Right now I have set up the follwing IF-statement but it is rather a long formula, specifically if I want to add more weekly periods afterwards:
Date Range = IF('[DimDate] = DATE(2017;06;22);"22.-28.06";IF(''[DimDate] = DATE(2017;06;23);"22.-28.06";IF('[DimDate] = DATE(2017;06;24);"22.-28.06";IF('[DimDate] = DATE(2017;06;25);"22.-28.06";IF('[DimDate] = DATE(2017;06;26);"22.-28.06";IF('[DimDate] = DATE(2017;06;27);"22.-28.06";IF('[DimDate] = DATE(2017;06;28);"22.-28.06";"")))))))
Is there a way of doing it in a 'smarter' way? I am quite new to DAX...
Thanks
P
Hi pippo80,
You can also use the SWITCH function to add a date range column to you table in this scenario. The formula below is for your reference. :smileyhappy:
Date Range = SWITCH ( TRUE (); [DimDate] >= DATE ( 2017; 07; 22 ) && [DimDate] <= DATE ( 2017; 07; 25 ); "22.-28.07"; // Just need add a new condition row to add more weekly periods [DimDate] >= DATE ( 2017; 06; 22 ) && [DimDate] <= DATE ( 2017; 06; 28 ); "22.-28.06"; "others" )Regards
2 Replies
v-ljerr-msftMicrosoft Employee
Hi pippo80,
You can also use the SWITCH function to add a date range column to you table in this scenario. The formula below is for your reference. :smileyhappy:
Date Range = SWITCH ( TRUE (); [DimDate] >= DATE ( 2017; 07; 22 ) && [DimDate] <= DATE ( 2017; 07; 25 ); "22.-28.07"; // Just need add a new condition row to add more weekly periods [DimDate] >= DATE ( 2017; 06; 22 ) && [DimDate] <= DATE ( 2017; 06; 28 ); "22.-28.06"; "others" )Regards
