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 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
Solved! Go to Solution.
Hi @pippo80,
I can use measure:
Date Range = IF([DimDate] >= DATE(2017;06;22) && [DimDate] <= DATE(2017;06;28);"22.-28.06";"")))))))
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
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
Hi @pippo80,
I can use measure:
Date Range = IF([DimDate] >= DATE(2017;06;22) && [DimDate] <= DATE(2017;06;28);"22.-28.06";"")))))))
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |