Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to get current filter selected date in calculated column

Hi All,

 

I have two tables,

1-DimDate

2-Services

 

There is no relationship between them because for DimDate i am using date in Slicer to return only rows of Services which exist from and To dates, and it is working fine.

 

The issue is in Services table i want to create one calculate column in which i want to return current selected date of slicer so that i can use it for further calculation.

I am using below Dax but it is returning Blank.

 

var selectedperiod = MONTH(SELECTEDVALUE(DimDate[Date]))
return selectedperiod
 
any clue for this?
DAX Command
  • Barthel's avatar
    Barthel
    3 years ago

    Hey Anonymous,

    A slicer selection does not affect calculated columns. A slicer selection only affects the visuals on your pages. If you want to write a certain calculation based on a slicer selection, you will have to process this in a measure, which you can then place in a visual. 

1 Reply

  • Barthel's avatar
    Barthel
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hey Anonymous,

    A slicer selection does not affect calculated columns. A slicer selection only affects the visuals on your pages. If you want to write a certain calculation based on a slicer selection, you will have to process this in a measure, which you can then place in a visual.