Forum Discussion

pstanek's avatar
pstanek
Post Patron
9 years ago

Direct Query Year , month

Hi , I created  two calculated  columns in DAX  by functions Year , Month from date( It is direct query mode!!!!!).  But Table  where it was calculated is now too large.  Is there equivalent to calc...
Need Help
Tips and Tricks
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi pstanek,

 

Assume you connect to SQL Server database, you can get Year and Month columns use T-SQL Query like below:

 

 

 

Also you can use the Date.Year() and Date.Month() function to create columns in Query Editor.

 

 

 

Best Regards,
Qiuyun Yu

  • pstanek's avatar
    pstanek
    Post Patron
    9 years ago

    Thanks for idea, we are going to fix by spark connection.