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