Forum Discussion

papasfritas's avatar
papasfritas
New Member
7 years ago

Month to Date AND Year on Year Dax In Direct Query

Hello   I am accessing data via direct query into a data cube.   There are two different date measures held in the data. The first is the date of sale. The second is the date that the service wil...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi papasfritas,

 

Do you have a Date table that contains future dates? If you'd like to analyze future data, there should be a future date. 

Since it's a live mode, I would suggest you create such a measure in the Cube.

 

 

Best Regards,

papasfritas's avatar
papasfritas
New Member
7 years ago

Thanks for the response.

 

Yes, there should be an option created in the cube, however I know it can't happen soon, so I'm looking for a solution in the interim.

 

thanks

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi papasfritas ,

     

    I'm afraid there isn't much we can do with the Live connection. Please refer to the snapshot below.Month-to-Date-AND-Year-on-Year-Dax-In-Direct-Query

     

     

    Best Regards,