Forum Discussion

bibhash_21's avatar
bibhash_21
Frequent Visitor
7 years ago
Solved

Get Dynamic date in slicer

Hi,

I have 2 date slicer, I want to when I select a date in 1st slicer then 2n slicer contain only greater date of 1st slicer.

I have create a calender table 

Date1 =
ADDCOLUMNS (
CALENDAR (DATE(2019,6,1), NOW()),
"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
"Year", YEAR ( [Date] ),
"Monthnumber", FORMAT ( [Date], "MM" ),
"DateTime",FORMAT([Date],"YYYY/MM/DD 8:00 AM/PM")
)
and also create a 2nd calender table
CurrentDate =
var sdd = SELECTEDVALUE(Date1[Date].[Date],NOW())
RETURN
ADDCOLUMNS (
CALENDAR (sdd, DATE(2020,5,31)),
"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
"Year", YEAR ( [Date] ),
"Monthnumber", FORMAT ( [Date], "MM" ),
"DateTime",FORMAT([Date],"YYYY/MM/DD 8:00 AM/PM")
)
But this is not work.
help me pls.
 
Thanks 
Bibhash Jha
Need Help
Tips and Tricks
Tutorial Requests
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, bibhash_21 

    First, you should know that calculated column and calculated table can't be affected by any slicer. 
    Notice:
    1. Calculated column/table not support dynamic changed based on filter or slicer, they  are "static" , will not respond to filters.
    2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.

    Best Regards,

    Lin

2 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, bibhash_21 

    First, you should know that calculated column and calculated table can't be affected by any slicer. 
    Notice:
    1. Calculated column/table not support dynamic changed based on filter or slicer, they  are "static" , will not respond to filters.
    2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.

    Best Regards,

    Lin

    • bibhash_21's avatar
      bibhash_21
      Frequent Visitor
      7 years ago

      Thaks for answer,

      Now, How can achhive that.

      v-lili6-msft wrote:

      hi, bibhash_21 

      First, you should know that calculated column and calculated table can't be affected by any slicer. 
      Notice:
      1. Calculated column/table not support dynamic changed based on filter or slicer, they  are "static" , will not respond to filters.
      2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.

      Best Regards,

      Lin