Forum Discussion

Singh_p's avatar
Singh_p
New Member
5 years ago

Convert a column to date data type

Hello, 

 

I am using a live database connection . Need to calculate inventory difference for present and past months .                               However the months is not in 'date' datatype and it is causing a problem.

 

I tried to create a new measure to convert it into date data type but since it is also a measure it is not accepted in quick measures for further calculation. 

 

 

 

Please suggest a solution. Thanks in advance. 

1 Reply

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    Hey Singh_p ,

     

    can you give more details about the data source.

    If it's a live connection it means you connect to a Power BI Dataset or an Analysis Services Tabular model. Or do you mean direct query, what is querying a relational database during runtime?

    Or do you mean the new composite model, what is in preview and allows a direct query of Azure AS and Power BI datasets?

     

    But live database connection is not precise enough, because with all different modes a lot of things differ.

     

    Thank you and best regards

    Denis