Forum Discussion
Change visual sorting based on weeks
Hi jaryszek ,
Please follow below steps.
1. In Query editor, I have created new column (Data-Copy) based on
'Date' column in 'Dim_Date' table.2. I have done some transformation on (Data-Copy) like change the language and datatype, created custom column with weekday values.
3. I have created table (table) with Weekday and Sort columns.
and merged the new table with existing 'Dim_Date' table. and i have expanded the table and removed blank columns.4. You can see the 'APPLIED STEPS' in Query editor, it will show each and every steps. Please refer below snap.
If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
Thank you.
How this is working?
I see you merged tables and filter them somehow...
Best,
Jacek
Hi jaryszek ,
Please follow below steps.
1. In Query editor, I have created new column (Data-Copy) based on
'Date' column in 'Dim_Date' table.
2. I have done some transformation on (Data-Copy) like change the language and datatype, created custom column with weekday values.
3. I have created table (table) with Weekday and Sort columns.
and merged the new table with existing 'Dim_Date' table. and i have expanded the table and removed blank columns.
4. You can see the 'APPLIED STEPS' in Query editor, it will show each and every steps. Please refer below snap.
If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.