Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
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?
Regards
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.
I can't understand. Could you share your calculation / report.
By Gnanasekar
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |