In my powerbi file I have several calculated columns.
My organization uses PowerBI 2021 September version.
Problem I'm having is with this one in particular: I'm calculating difference in minutes between two datetime columns. Another column is created to assign ID ranges to time for instance if time difference is less than 30 minus I'll return 1 for its range. I have another ranges and labels table which is connected to my table on this calculated ID of 1 with corresponding text label "<30 min" that I'm using to display in a table visual. Wherever it's possible I'm using SWITCH statement.
If I refresh the report (it's based on import query) on desktop ranges are assigned correctly and where it's calculated range is 1, it's getting assigned correct range but when the report is published to the server instead of "<30 min" it might display "4-8hours".
Can anyone suggest what can be potentially wrong or how do I debug to find the issue?
