Advanced DAX - Sales First 365 Days

[Anonymous]

Hello, 

Downloadable PBIX File Link: https://drive.google.com/file/d/1S4GrIimMe0lvc3MdVf9HM0ZN-Ze6ykg6/view?...

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]

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

    )

)

[amitchandak · Accepted solution]

@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))