I would like to create a world local time dashboard.
My though is to create a parameter and let the reader input their local time. The dashboard will then automatically show the corresponding time of each country.
I now have an excel spreadsheet which includes country name and GMT +/- hour.
I tried to create a parameter and do a sum but firstly, the parameter does not accpt hour only option and second the sum will show a negative number which is actually a night time. (e.g. 1am GMT – 5 = - 4 local time, but actually it should be 8pm local time.)
Do you have any idea I can wotk on this?
I think you need to be using DATEADD instead of SUM. DATEADD('hour',[Your Param],[Your Date]).