Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hai Expert,
I need to creata a dax that will shows dash (-) when user choose year slicer 2023 onwards , this dash is to replace value null/blank for the year 2023 onwards.
Hi, @Julaiha
Here is the sample DAX based on your requirement.
Measure =
CALCULATE(
MAX('YourTable'[OriginalColumn]),
FILTER(
'YourTable',
'YourTable'[Year] < 2023
)
) & IF(MAX('YourTable'[Year]) >= 2023, "-", "")
Proud to be a Super User!
@Julaiha Is this required in a slicer or what? Share an image on what the requirement is.
User | Count |
---|---|
88 | |
88 | |
74 | |
68 | |
58 |
User | Count |
---|---|
136 | |
110 | |
91 | |
84 | |
69 |