https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Creating-single-Parameter-for-multiple-tables-and-that-Passing/m-p/720870#M2287 <P>Hi,</P><P>&nbsp;</P><P>I have 15 tables coming from SQL Db in my data modal and Each table contains minimum 2 to 4 different date columns. now we want to create common DAX&nbsp; for month, year, date, weekday, weeknumber, day for all tables.</P><P>so that we need to pass the parameter. But I'm not able to create a parameter (without refering a table) which I can use for all the tables and calling that in Dax.</P><P>&nbsp;</P><P>That single Parameter and 6 Dax should be useful for all 15 tables, to show&nbsp;month, year, date, weekday, weeknumber, day seperately.</P><P>&nbsp;</P><P>If anyone have solution, please share..</P><P>&nbsp;</P> Fri, 21 Jun 2019 09:42:34 GMT Jyotisha 2019-06-21T09:42:34Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Creating-single-Parameter-for-multiple-tables-and-that-Passing/m-p/720870#M2287 <P>Hi,</P><P>&nbsp;</P><P>I have 15 tables coming from SQL Db in my data modal and Each table contains minimum 2 to 4 different date columns. now we want to create common DAX&nbsp; for month, year, date, weekday, weeknumber, day for all tables.</P><P>so that we need to pass the parameter. But I'm not able to create a parameter (without refering a table) which I can use for all the tables and calling that in Dax.</P><P>&nbsp;</P><P>That single Parameter and 6 Dax should be useful for all 15 tables, to show&nbsp;month, year, date, weekday, weeknumber, day seperately.</P><P>&nbsp;</P><P>If anyone have solution, please share..</P><P>&nbsp;</P> Fri, 21 Jun 2019 09:42:34 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Creating-single-Parameter-for-multiple-tables-and-that-Passing/m-p/720870#M2287 Jyotisha 2019-06-21T09:42:34Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Creating-single-Parameter-for-multiple-tables-and-that-Passing/m-p/721453#M2292 <P>Hi,</P><P>&nbsp;</P><P>I am afraid that DAX is out of our expertise.</P><P>You should ask in <A href="https://community.powerbi.com/t5/DAX-Commands-and-Tips/bd-p/DAXCommands" target="_self">this thread</A>.</P><P>&nbsp;</P><P>Kind Regards,</P><P>&nbsp;</P><P>Evgenii Elkin,<BR />Software Engineer<BR />Microsoft Power BI Custom Visuals<BR />pbicvsupport@microsoft.com</P> Fri, 21 Jun 2019 15:10:45 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Creating-single-Parameter-for-multiple-tables-and-that-Passing/m-p/721453#M2292 v-evelk 2019-06-21T15:10:45Z