cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jacob1832
Frequent Visitor

User Input Date in DAX column in POWER BI

I am trying to create a column in Power BI to group the rows of that data on. I want the column to output text based on a comparison of dates.

Example: projected = if(staticdate1 > dynamicdate, "XX", if(staticdate1 < dynamicdate && staticdate2 > dynamicdate, "YY", .... )

The dynamicdate presumably would be a filter or slicer the user could click a date on, thus changing the output of the column, and the totals per output would also change.

Is this possible? I've tried SELECTEDVALUE() but that didn't work. I tried creating a "what-if" parameter and adding that to a static date, but that didn't change anything when I changed the parameter.

4 REPLIES 4
Ashish_Mathur
Super User
Super User

Hi,

Calculated column formulas do not respond to a change in slicers.  Please describe the question, share some data and show the expected result. 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

I am trying to create a column in DAX that responds to a date parameter that the user can define. The output would be text like is shown in the Example i gave, and that result should change if the date chosen by the user changes. 

Calculated columns do not work that way.  Read my previous reply.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Thank you

 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.