Forum Discussion

tsarun1992's avatar
tsarun1992
Icon for Helper I rankHelper I
3 years ago

Date data in Direct query

Hello All,   I have created a data model in SQL to display LIVE Data of Sales, wherein I have a column of Date.  The data is pulled into BI using "Direct Query". Though the date column is in Da...
Need Help
mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
3 years ago

Hi tsarun1992 ,

 

In direct query, you are not allowed to create a calculated column?

  • tsarun1992's avatar
    tsarun1992
    Icon for Helper I rankHelper I
    3 years ago

    Yes we can create calculated columns, but certain DAXes are not allowed to use in Direct query data. The following DAXes are needed for my report but unable to use

     

    1. DATEDIFF

    2. CONCATENATEX

    3. LOOKUPVALUE

    • mussaenda's avatar
      mussaenda
      Icon for Community Champion rankCommunity Champion
      3 years ago

      Hi tsarun1992 ,

       

      but you can do a column to extract the month, and/or year?