Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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))
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
)
)
@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))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
87 | |
74 | |
66 |
User | Count |
---|---|
124 | |
113 | |
96 | |
80 | |
72 |