Calculate nr of sessions per period

[emveha]

hi all,

have a simple table with sessions (just a number) and a date presented like 1-1-2017 and now i want to know the sessions per period. So what i have done is i added a custom column = Year (Date.Year(Date)) and as a result i get 2017 and 2018. How should i create a calculation that will show me the nr of sessions for 2017 and 2018...

Any ideas, thanks

M

[emveha · Accepted solution]

Hi Lydia,

thanks for your support, appreciate it and need to apologize as  well as i was not clear enough....What i was looking for was a new measure that would presented the number of sessions in 2017 and 2018. In the meantime, I managed to solve the issue like this--> Sessions TY = CALCULATE(SUM('TableXX'[Sessions]);'TableXX'[Year]="2018";'TableXX'[YTD]="YTD") and this was exactly what i was looking for.

Again thanks for support!

M

[v-yuezhe-msft]

@emveha,

Please check attached PBIX file, if it doesn't meet your requirement, please share sample data of your table and post expected result here.

Regards,
Lydia