Hi everyone,
I'm currently transitioning to PowerBi and is in a bit of mess with converting excel formulas to DAX.
I am tryin to get the number times the store_number has appeared each day the get the average number of times it appeared for the month or week.
thank you in advance as this site as been my lifeline since I joined
here is my data sample: [TABLE="width: 80"]
<colgroup><col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"><tbody>[TR]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][TABLE="width: 234"]
<colgroup><col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"> <col width="59" style="width: 44pt; mso-width-source: userset; mso-width-alt: 2157;"> <col width="147" style="width: 110pt; mso-width-source: userset; mso-width-alt: 5376;"> <tbody>[TR]
[TD="width: 107, bgcolor: #BFD2E2"]Ticket_Number[/TD]
[TD="width: 59, bgcolor: #BFD2E2"]FullDate[/TD]
[TD="width: 147, bgcolor: #BFD2E2"]Issue_Store_Number[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583339[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]14167[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583380[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]13586[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583383[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]366[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583429[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]214[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583473[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]15777[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583492[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]19801[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583513[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]15311[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583514[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]9117[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583628[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]10310[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583662[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]12887[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583684[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]17994[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583742[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]76[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583759[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]13835
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583765[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]2846[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583782[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]13088[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583829[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]1182[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583831[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]8899[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583832[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]9260[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
I'm currently transitioning to PowerBi and is in a bit of mess with converting excel formulas to DAX.
I am tryin to get the number times the store_number has appeared each day the get the average number of times it appeared for the month or week.
thank you in advance as this site as been my lifeline since I joined
here is my data sample: [TABLE="width: 80"]
<colgroup><col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"><tbody>[TR]
[TD="width: 107, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][TABLE="width: 234"]
<colgroup><col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"> <col width="59" style="width: 44pt; mso-width-source: userset; mso-width-alt: 2157;"> <col width="147" style="width: 110pt; mso-width-source: userset; mso-width-alt: 5376;"> <tbody>[TR]
[TD="width: 107, bgcolor: #BFD2E2"]Ticket_Number[/TD]
[TD="width: 59, bgcolor: #BFD2E2"]FullDate[/TD]
[TD="width: 147, bgcolor: #BFD2E2"]Issue_Store_Number[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583339[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]14167[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583380[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]13586[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583383[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]366[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583429[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]214[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583473[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]15777[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583492[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]19801[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583513[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]15311[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583514[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]9117[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583628[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]10310[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583662[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]12887[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583684[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]17994[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583742[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]76[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583759[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]13835
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583765[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]2846[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583782[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]13088[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583829[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]1182[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583831[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]8899[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2001583832[/TD]
[TD="bgcolor: transparent, align: right"]12/1/18[/TD]
[TD="bgcolor: transparent, align: right"]9260[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]