Forum Discussion
Adding predefined date slicers e.g. semester 1
Sorry but I don't understand how does that solve the problem. I still cannot define a range of dates using If statement.
I need to the additional coloumn to look at the date then return a string based on the value
so for example from 21Feb 2022 to 05 June 2022 RETURN Semester 1
&& from 14 Feb 20222 to 20 Feb 2022 RETURN Orientation Sem 1
&& from 05 June to 11 Nov 2022 RETURN Semester 2
and so on
Hi SusuYes,
Account to your description, it sounds like you want to create a dynamic calculated column/table based on filter/slicer effects. If that is the case, current power bi does not support these, calculated column/table and filter are work on different data levels.
For this scenario, I'd like to suggest you use measure expression instead, it hosts on the same level of filter and they can be dynamic changes based on filter selections. (you can use it as a measure filter on 'visual filter level' to apply filter effects)
Applying a measure filter in Power BI - SQLBI
Notice: the data level of power bi.
Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)
Regards,
Xiaoxin Sheng