Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 calculate year, month, from date in Query editor in Direct query mode? An is it faster?
Do you have another idea how to make it faster? Maybe create table calendar in database.
I use thse columns as filter nad that is the problem, You can see empty square and that is exactly filter with calculated column year.
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
Thanks for idea, we are going to fix by spark connection.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |