Grobari4 (for want of a better name)
Could you upload 10 rows of the data. (You can mask the names , etc )
Yeah, I'm about to change my screen name..Just a quick one, might sounds silly but what do you mean 10 rows of data. Unfortunately I can't share the workbook cause it's linked to datasources accessed only through vpn and apparently contain sensitive data. Would any screenshot help?
Basically, I tried to mock it up..I created a calculated field named Reference and just make it equal to my measure: MQL_TO_SAL_DAYS. Now, I'm trying to create a calculated date field in the form of:
IF [REFERENCE] is MQL_TO_SAL_DAYS then I want the calculated field to be equal to the value of the dimension "MQL_DATE". But I get errors, either using IF or CASE..because it can't compare float vs strings apparently. Any ideas how to build that?