Forum Discussion
Japanese UI: Earliest/Latest date labels reversed
Hey, you're not imagining it... This is a localization thing, not a data or calc issue.
The actual aggregation is language independent. Earliest is just MIN and Latest is just MAX under the hood, so the fact that English gives you the right results proves the math is fine. The Japanese strings are just mislabeled.
Quick workaround until MS fixes it: don't trust the Japanese dropdown labels, just remember Earliest = MIN, Latest = MAX. Or skip the visual dropdown and use explicit measures:
Earliest Date = MIN('Table'[Date]) Latest Date = MAX('Table'[Date])Those won't get touched by the UI translation at all.
For getting it actually fixed, drop it on the Fabric Ideas site or use the in product feedback (Help > Send Feedback). Translation bugs go to the localization team, not regular support, so that's the faster path.
If this works for you, kindly mark it as the solution and give a thumbs up.
Best,
Shai Karmani
Super UserHey, you're not imagining it... This is a localization thing, not a data or calc issue.
The actual aggregation is language independent. Earliest is just MIN and Latest is just MAX under the hood, so the fact that English gives you the right results proves the math is fine. The Japanese strings are just mislabeled.
Quick workaround until MS fixes it: don't trust the Japanese dropdown labels, just remember Earliest = MIN, Latest = MAX. Or skip the visual dropdown and use explicit measures:
Earliest Date = MIN('Table'[Date])
Latest Date = MAX('Table'[Date])Those won't get touched by the UI translation at all.
For getting it actually fixed, drop it on the Fabric Ideas site or use the in product feedback (Help > Send Feedback). Translation bugs go to the localization team, not regular support, so that's the faster path.
If this works for you, kindly mark it as the solution and give a thumbs up.
Best,
Shai Karmani
Thank you for your response and for pointing me in the right direction.
I have submitted this issue to Fabric Ideas as a Japanese localization bug.
I appreciate your help.