topic Re: get the base number from rn date in DAX Commands and Tips

get the base number from rn date

ROG — Tue, 01 Nov 2022 12:01:27 GMT

Hi everyone,

The dax below gives me the number of subscribers that have optin to our marketing campaings by email.

base check= CALCULATE([Subscribers_Email], ALL(data_history_append_update[EMAIL_OPTIN_FLAG]))

Given that the report refreshes once a week (every Monday), how can I get the AVG of this base by week and by month?

Thank you.

amitchandak — Tue, 01 Nov 2022 13:47:14 GMT

ROG , Assuming you are using date table

measures

week =

averagex(Values('Date'[Week Year]), [base check])

Month =

averagex(Values('Date'[Month Year]), [base check])

ROG — Tue, 01 Nov 2022 16:27:13 GMT

Thanks a lot amitchandak !