https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-needed/m-p/889723#M7815 Hi All,i have three date coulmns like last 3,6,12 months..the data should be populated based on user selection of the date column..how to add three date coulmns to single slicer /filter? Any thoughts Sun, 05 Jan 2020 06:54:14 GMT Anonymous 2020-01-05T06:54:14Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-needed/m-p/889723#M7815 Hi All,i have three date coulmns like last 3,6,12 months..the data should be populated based on user selection of the date column..how to add three date coulmns to single slicer /filter? Any thoughts Sun, 05 Jan 2020 06:54:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-needed/m-p/889723#M7815 Anonymous 2020-01-05T06:54:14Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-needed/m-p/889725#M7816 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;</P><P>you can on Power QUery mode pick your 3 date columns then right click and Unpivot only selected columns.</P><P>after that it appears one column which could be added as slicer</P><P><STRONG><I><FONT color="#ababab">do not hesitate to give a kudo to useful posts and mark solutions as solution</FONT></I></STRONG></P> Sun, 05 Jan 2020 07:14:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-needed/m-p/889725#M7816 az38 2020-01-05T07:14:33Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-needed/m-p/889885#M7830 <P><EM>thanks for your response. I have been using SSAS data model ,so there is no pivot query option.</EM></P> Sun, 05 Jan 2020 21:14:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-needed/m-p/889885#M7830 Anonymous 2020-01-05T21:14:10Z