Good idea. I never explored this before ! Thanks. The measure option however doesn't offer to group by the SUM of stays and this is what I am looking for. They are only listed simple measures. Regards

Yes, I was thinking about other ways but did then the display will be completely different. There are two many pre-calculated measures involved as well as joining of same table. I changed the format now and hoping that this maybe would be easier to achieve in new calculated items. I would the pickup (06-Apr-18 - 30-Mar-18)…

Hi Gianni, The dates are attributes of the snapshotdate dimension and are obtained with a timestamp function. I tried the CASE function on just one of the columns to test , but i am getting a syntax error. I might doing a thinking mistake though. Tried values in single quotes as well with same results.

I added screen shots. Hope this is more clear now.

This is what i am trying to do. The pickup column is based on new calculated items. It is substracting the last two dates. From ROOM vs YAGO onwards, I would like to show null under Pickup. Would you build the case function in the new calculated items or would you create an additional column? Thanks

Ciao Gianni, thanks for your prompt answer. I am not an expert and though I know case functions, i wouldn't know how to use them in the new calculated items. I will give a try though. Thanks and Regards Giuliano

Hi Robert, Could you please more specific, as I am not an expert. Where would I do that exactly?