Dynamic date column based on slicer

[Gnanasekar]

Hi All,

How can I get dynamic date column based on between slicer?

EX: Table Name         : A

      Column Name     : Filter date = 2009/01/01 to 2017/09/18

I calculated measure & Column use of same formula

Measure : 

Min date measure = min(A[Filter date])  

Column: 

Min date Column= min(A[Filter date])  

*My slicer range : Between (2017/01/01, 2017/08/15)

Result should be " 2017/01/01"

But I got,

             Min date measure : 2017/01/01

             Min date Column : 2009/01/01 <-- column not filter out based on slicer.

I need 2017/01/01 in column.

How can I get it?

By

Gnanasekar

[v-ljerr-msft]

Hi @Gnanasekar,

Not like measures, calculate columns/tables are computed during database processing(e.g. data refresh) and then stored in the model, they do not response to user selections on the Slicers.

So it is not possible to create a calculate column/table can change dynamically with user selections on the Slicers. 

Reference: Calculated Columns and Measures in DAX

Regards

[Gnanasekar]

Hi @v-ljerr-msft

Is the any other way to achieve dynamic date column based slicer?

I need to further calculation based on dynamic date column.

By

Gnanasekar

[v-ljerr-msft]

Hi @Gnanasekar,

---

I need to further calculation based on dynamic date column.

---

Could you be more precisely with the further calculation, so that I can help to check if there is a way to use a measure instead? 

Regards

[Gnanasekar]

Hi @v-ljerr-msft

I have attached my full calcualtion link.

https://community.powerbi.com/t5/Desktop/How-to-calculate-prorate-value/m-p/259872

Here,

Filter Start Date  column (min date value of filter) and Filter End Date column (max date value of filter) should contain dynamic date value based on "between date slicer".

By

Gnanasekar

[wildmight2017]

You could calculate 1 column with range of your min and max dates (could be a case statement using your regular time dim) - then drop the slicer and pull min and max values to the extremes - this worked for me under the same requirement. 

[Gnanasekar]

Hi @wildmight2017

I can't understand. Could you share your calculation / report.

By Gnanasekar