tag:blogger.com,1999:blog-5650243067310933543.post5289209902054532583..comments2024-03-21T05:34:12.449+01:00Comments on BI Future Blog: DAX : Some DAX QTD, YTD and LY calculations with a Period DimensionHennie de Nooijerhttp://www.blogger.com/profile/04946694074745643589noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5650243067310933543.post-83754126347640016562016-06-10T09:55:34.209+02:002016-06-10T09:55:34.209+02:00Hi Prasad,
Thank you for the kind words.
I thin...Hi Prasad,<br /><br />Thank you for the kind words. <br /><br />I think you want to sum figures per day in a week? Like sun = 500, mon = 700 and that per year?<br /><br />Do you have a calendar dimension? In my calendar dimension, I have day attribute and a year attribute. I you put that in a pivottable the measures are automatically filtered and with explicit measure with a SUM you have your results.<br /><br />Hope that this helps<br /><br />HennieHennie de Nooijerhttps://www.blogger.com/profile/04946694074745643589noreply@blogger.comtag:blogger.com,1999:blog-5650243067310933543.post-44919768238601004512016-06-09T09:06:09.463+02:002016-06-09T09:06:09.463+02:00Hi,
Nice post I have read ever. I have a query. Co...Hi,<br />Nice post I have read ever. I have a query. Could you please send me a measure which can calculate sum of the things of day of the week in a give year? I mean it should show me the results in such a way that the sum of all Sundays, Mondays, Tuesday.....etc., of a given year data.<br />Regards,<br />PrasadPrasadhttps://www.blogger.com/profile/08893645499924771903noreply@blogger.com