Forum Discussion
How we can user user input parameter in a column with DAX formula to change a date
Hello Users, I want to use user input parameter to calculate a past date from a date column which is already present in cloud dataset. for example: user select 4 as a integer from user input slicer ...
Hi Anonymous,
Current power bi does not support creating dynamic calculated column/table based on filter selections. I'd like to suggest you create a measure to interact with the 'what if' parameter slicer.
SELECTEDVALUE function - DAX | Microsoft Docs
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