Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I want to get the max of the two selected dates and flag it as 1 if it is equal to the MAX of the selected date.
Selected dates from the slicer:
Table:
Here in the table of the selected dates i want to flag the smaller date as 0 and latest selected date as 1.
Can you please help
Solved! Go to Solution.
@Anonymous , try like
measure =
var _max = maxx(allselected(Date),Date[date])
return
if(max(Table[asofdate]) = _max ,1, 0)
@Anonymous
Is Cross Filtering form (Format Tab> Interaction) enabled between these two visuals?
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous , try like
measure =
var _max = maxx(allselected(Date),Date[date])
return
if(max(Table[asofdate]) = _max ,1, 0)
Hi,
When i select other dates like as shown in screenshot it does not work:
Here the previous date should show flag as 0 but it is showing as 1:
Hi @amitchandak
I am facing one problem with the solution.
I have selected two dates in my slicer but when i filter the records (example filter applied on a item location code ) present only in the past date using the filter pane the measure returns 1 eventhough i have selected two dates in myslicer.
I get how the measure is working on the basis of data present in the filter and as the visual has only one date it will show as 1.
I want the measure values to be based on the selection in slicer only and not on the visual data.
Can you please help me with that as wothout this my another measure(which uses the date measure too) changes it's value as the user filters further more
@Anonymous , check i tried the same
Hi @amitchandak
Thank you for the solution it worked as expected.
Previously i selected only one filter from the report level filter and that is why i was confused.
But now i understood. Thank you for the help.🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
77 | |
50 | |
46 | |
16 | |
12 |