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:
<colgroup><col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"><tbody>
</tbody>
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:
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<colgroup><col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"><tbody>
</tbody>