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 ...
Thanks for your reply.
but we cant create measure for date field right..?
i tried it but date is not possible in measure.
correct me if I am wrong.
HI Anonymous,
You can try to create a query parameter and turn on the 'enable load' option on the query editor side.
Deep Dive into Query Parameters and Power BI Templates | Microsoft Power BI Blog | Microsoft Power BI
This parameter table will be loaded into the data model, then you can use your formula to extract this table values to calculate with your expression.
After these steps, you can modify the parameter and refresh the data model table to update the calculated column result based on the parameter table values.
Regards,
Xiaoxin Sheng