Forum Discussion
Analysing point in time data
there is a DateAdd function in DAX so that you can establish the time interval between event times - and then graph that. You posted in Service and this data modeling would really need to occur in Desktop and then publish the report to service.
it doesn't sound like you want a daily plot - but that could be established by adding a Calendar table.
- Ok thanks, we're using the service as the data we are using is pushed there directly by a connector in Azure so it's only accessible in the service. I guess to use the desktop version I'd need to get it into a database or similar and then use that?
while I tend to think it would be best modeled in desktop - - there are others here at the community that are more advanced at doing things at the Service so I would defer to them - - hopefully one will visit this post and contribute...
desktop can connect and auto refresh to Azure with a gateway - so no 3rd db is going to be involved.... one can proto type with a manual Get Data before installing the gateway as a sanity test that the linking is capabile but since you have it already at Service then it is a high probable to be okay....
you also may download your Service report to a desktop pbix file though not sure if that offers a gain.....
