Naming specific dates for filtering afterwards

[pippo80]

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

[pmhoang94 · Accepted solution]

Hi @pippo80,

I can use measure:

Date Range = IF([DimDate] >= DATE(2017;06;22) && [DimDate] <= DATE(2017;06;28);"22.-28.06";"")))))))

[v-ljerr-msft · Accepted solution]

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. 

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

[pmhoang94 · Accepted solution]

Hi @pippo80,

I can use measure:

Date Range = IF([DimDate] >= DATE(2017;06;22) && [DimDate] <= DATE(2017;06;28);"22.-28.06";"")))))))