Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Advanced DAX - Sales First 365 Days

Hello,    Downloadable PBIX File Link: https://drive.google.com/file/d/1S4GrIimMe0lvc3MdVf9HM0ZN-Ze6ykg6/view?usp=sharing Context: I am trying to iterate on my DAX, in order to show sales for the ...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

    )

)