Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Gnanasekar
Helper III
Helper III

Dynamic date column based on slicer

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

 

 

6 REPLIES 6
v-ljerr-msft
Employee
Employee

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. Smiley Happy

 

Reference: Calculated Columns and Measures in DAX

 

Regards

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

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? Smiley Happy

 

Regards

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

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. 

Hi @wildmight2017


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

By Gnanasekar

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.