Forum Discussion

ignas's avatar
ignas
Advocate II
8 years ago
Solved

Dynamic column values based on selected date. Need help

Hello   I have this data:     I want to have a date parameter. If I choose 01-04-2018 date then it would mean that all dates before 01-04-2018 are actual and all dates from 01-04-2018 are ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi ignas,

     

    The solution could be as follows.

    1. Create an independent date table. Don't establish relationships with other tables.

    2. Create a slicer.

    3. Create a measure like below.

    Measure 9 =
VAR selectedDate =
    IF ( HASONEVALUE ( 'Table8'[Date] ), MIN ( 'Table8'[Date] ) )
RETURN
    IF ( MAX ( DimDate[Datekey] ) <= selectedDate, "Actual", "Forecast" )

    Dynamic_column_values_based_on_selected_date_Need_help

     


    Best Regards,

    Dale

ignas's avatar
ignas
Advocate II
8 years ago

Hey v-jiascu-msft

 

Thank you for the response.

Yes of course I need different colors:

We need to know when ACT finished and when BUD/FC starts.

 

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi ignas,

 

As a workaround, we can change the measure and put it in the field "Color saturation".

Scenario+ = 
    IF ( MAX ( DimDate[Datekey] ) <= IF ( HASONEVALUE ( 'Table8'[Date] ), MIN ( 'Table8'[Date] ),"Actual"), 1, 0 )

Dynamic_column_values_based_on_selected_date_Need_help2

 

Best Regards,

Dale