Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Xero app, default dates, DAX

Hey,

 

I have just connected to the Xero app which has pulled through all my data. However, I have a few issues, I have experience on desktop, but havent spent too much time on service.

 

Questions:

1. One of the preloaded charts under Value has Monthly Sales, Monthly Expenses (+). This monthly expenses isn't a field in the list so im not too sure where it has come from? Also I would like to know how to change that value from the default which is a negative value, into the (+) value.

 

2. Is there anyway to do any DAX, or calculations of any kind in Service?

 

3. How do I change the default FY? Our year ends March 31st, however all the FY are thinking June is the end?

 

Thank you in advance!

 

Dan

Need Help

1 Reply

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    All the content you describe cannot be performed on the service, only the owner of the app can modify it on the desktop, and then publish to service. Then these changes will be reflected in the user who installed the app. You can view the data model in edit view:

     

     

    >>How do I change the default FY? Our year ends March 31st, however all the FY are thinking June is the end?

     

    Please refer to https://www.powerobjects.com/blog/2018/12/19/sorting-data-fiscal-year-power-bi/

     

    Best Regards,

    Dedmon Dai