Question 356
You have a semantic model that contains two tables named Sales and Date. The Sales table relates to the Date table by using a many-to-one relationship. The Sales table contains the following columns:
* Date
* Product
* SalesAmount
You need to create a DAX measure for a rolling 31 -day sales total that will return the total sales amount for a selected date and the previous 30 days.
Which DAX expression should you use?
* Date
* Product
* SalesAmount
You need to create a DAX measure for a rolling 31 -day sales total that will return the total sales amount for a selected date and the previous 30 days.
Which DAX expression should you use?