Forum Discussion

SniperPro's avatar
SniperPro
Frequent Visitor
3 years ago

Calculating YTD while keeping Month filter

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...
"DAX"
DATESYTD Help needed
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi SniperPro 

try like:

 

Measure = 
CALCULATE(
     SUM(TableName[Value]),      
     YEAR(TableName[Date])=YEAR(MAX(TableName[Date])),
     TableName[Date]<=MAX(TableName[Date])
)

 

 

it worked like:

 

SniperPro's avatar
SniperPro
Frequent Visitor
3 years ago

FreemanZ Is it possible to have this same formula using the date from the related calendar table and not from the TableName.