Latest date net dax.

[ROG]

Hi all,

Can you please help me with a dax measure thats give me the - 

Number of Active Customers for each last day of the week?

Number of Active Customers is a sum of a column from a table called subscriber, where the table doens't have any date column.

The date comes from a calendar table, which is a very complete type of Dim_Date.

I found the example below, but given that the date in my case comes from another table, not sure what to do. 
LastSalesDate = MAX ( Sales[Order Date] )


Thanks a lot!

[v-cgao-msft]

Hi @ROG ,

Need more information:

What fields are in the 'Subscribers' table? Can any of these fields create a relationship with the calendar table?

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Anonymous]

Lastdayofweek_sale = calculate(sum('Table'[Active Customers]),dateadd(date_dim[date],7,day))

I dont know exactly if you have to use sum or max for active customers but it will work.