Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have bellow table data:
I want to add a measure calculating the YTD of Value so I added this measure :
Mesure = CALCULATE(SUM('Table'[Value]), DATESYTD('Calendar'[Date]))
Then in my report I filtered on the month 202302, I have the correct result puting the month and the measure :
But when I add the product it's showing two lignes :
How can I modify the measure to have just the filtered month 202302, the product2 and Measure ytd = 3.
hi @SniperPro
try like:
hello @FreemanZ
I want to add a month filter on the report page level :
Then I want to see the product on this month (Product2) and the YTD Value on this month alose (3)
Below the result that I want to see :
hi @SniperPro
it is always adivisable to have a dimensional date table. Supposing you have one, then try like:
Measure2 =
CALCULATE(
SUM(TableName[Value]),
DATESYTD(DateTable[Date])
)
or
Measure3 =
TOTALYTD(
SUM(TableName[Value]),
DateTable[Date]
)
it worked like:
hi @SniperPro
try like:
Measure =
CALCULATE(
SUM(TableName[Value]),
YEAR(TableName[Date])=YEAR(MAX(TableName[Date])),
TableName[Date]<=MAX(TableName[Date])
)
it worked like:
@FreemanZ Is it possible to have this same formula using the date from the related calendar table and not from the TableName.
On the filter pane to the right, in the "Filters on this visual" section, under the Product column - > Choose Basic Filtering - > Then Choose "Product2"
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
23 | |
22 |