https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Help/m-p/70073#M76 <P>summarize(Table,<SPAN>Table[Date],Table[Geo],Table[City],"Values",Calculate(Values(Table[Value]))</SPAN>)</P> Tue, 20 Sep 2016 15:59:26 GMT ryan-gao 2016-09-20T15:59:26Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Help/m-p/70006#M75 <P>Thanks Advanced.</P><P>&nbsp;</P><P><img></img></P><P>&nbsp;</P><P>The Screen in my input .</P><P>&nbsp;</P><P>Expected result is&nbsp;</P><P>&nbsp;</P><P><STRONG>Sep-16 &nbsp;- India &nbsp;- Airoli - 10</STRONG></P><P><STRONG>Oct-16 &nbsp;- India &nbsp;- Airoli - 20</STRONG></P><P>&nbsp;</P><P>How can i do with Dax ?</P><P>&nbsp;</P><P>am clueless !!!</P><P>&nbsp;</P><P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="313" data-lia-user-login="Greg_Deckler" class="lia-mention lia-mention-user">Greg_Deckler</a>&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="3812" data-lia-user-login="ankitpatira" class="lia-mention lia-mention-user">ankitpatira</a>&nbsp;Anonymous</a><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="11355" data-lia-user-login="v-haibl-msft" class="lia-mention lia-mention-user">v-haibl-msft</a></P> Tue, 20 Sep 2016 13:40:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Help/m-p/70006#M75 Baskar 2016-09-20T13:40:34Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Help/m-p/70073#M76 <P>summarize(Table,<SPAN>Table[Date],Table[Geo],Table[City],"Values",Calculate(Values(Table[Value]))</SPAN>)</P> Tue, 20 Sep 2016 15:59:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Help/m-p/70073#M76 ryan-gao 2016-09-20T15:59:26Z