I’m continuing to work on a new model and report using what I’ve learned from Sam and Enterprise DNA. My current issue probably has something to do with Dates and the inactive relationships that are in place. Attached is a masked model to work with (Thanks @Brian Julius for the video showing how to do this!!). And here are the questions associated with the visual on the Sales 365 report page.
- If the date filter is set on the page, the Sales Year to Date measure displays a number. But if you clear the filter, it goes back to null. What is wrong with this formula?
Sales Year to Date =
[Total Sales] ,
DATESYTD( Dates[Date] ) )
- We want to display sales from the past 365 days. I’ve tried 2 measures for this and they show 2 different answers. Neither of them are correct. Sales from 2 former salespersons appear in this visual, and neither of them should be showing up. Their last sales were more than 365 days in the past.
Sales 365 Days =
MAX( Billing[Ship_Date]), - 365, DAY)
)Sales Report Masked.zip (3.5 MB)
Sales 365 Days Attempt 2 =
- All orders have a salesperson associated with them. Why are sales showing in the visual without a salesperson?
Thanks for helping me figure this out.