Forum Discussion
Advanced DAX - Sales First 365 Days
Hello,
Context: I am trying to iterate on my DAX, in order to show sales for the first 365 days for a book, beyond 365 days of the published date.
Model:
Canvas: How can I get my 'Sales First 365 Days' Measure to not be blank in the table? The Measure is working as wanted in the bar chart.
Any links or hints is much appreciated!
Anonymous , Based on what I got from subject
Measure =
calculate(Sum('Fact book Sales'[Sales Amit]), Filter('Fact book Sales', 'Fact book Sales'[Sales Date] >= related(bookDIm[Published Date]) && 'Fact book Sales'[Sales Date] <= related(bookDIm[Published Date]) +365))
2 Replies
- amitchandak
Super User
Anonymous , Based on what I got from subject
Measure =
calculate(Sum('Fact book Sales'[Sales Amit]), Filter('Fact book Sales', 'Fact book Sales'[Sales Date] >= related(bookDIm[Published Date]) && 'Fact book Sales'[Sales Date] <= related(bookDIm[Published Date]) +365)) Thank you. That is what I was looking for amitchandak
test =
CALCULATE (
SUM ( 'Fact Book Sales'[Sales Amt] ),
FILTER (
'Fact book Sales',
'Fact book Sales'[Sale Date] >= RELATED ( DimBook[Published Date] )
&& 'Fact book Sales'[Sale Date]
<= RELATED ( DimBook[Published Date] ) + 365
)
)