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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
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))