Forum Discussion
Specific Dax calculation
- Anonymous2 years ago
Hii, once use the following commands, Just add your table name in it
1) DuplicateValue =
VAR CurrentRow = CURRENTROW()
VAR CurrentStatus = [Status]
VAR DuplicateRow = LOOKUPVALUE('YourTableName',
'Status', CurrentStatus, 'Status')
RETURN
IF(
ISBLANK(DuplicateRow),
CurrentRow[Value], DuplicateRow[Value] )
2) EstimatedCompletionDate =
VAR CurrentRow = CURRENTROW()
VAR CurrentStatus = [Status]
VAR AverageDuration = CALCULATE(
AVERAGE('YourTableName', 'Value'),
FILTER('YourTableName', 'Status' = CurrentStatus))
VAR StartDate = [Date]
RETURN
StartDate + AverageDuration
3) CombinedMeasure =
VAR CurrentRow = CURRENTROW()
VAR CurrentStatus = [Status]
VAR DuplicateValue = LOOKUPVALUE(
'YourTableName',
'Status',
CurrentStatus,
'Status'
)
VAR EstimatedCompletionDate = CALCULATE(
AVERAGE('YourTableName', 'Value'),
FILTER('YourTableName', 'Status' = CurrentStatus)
)
RETURN
IF(
ISBLANK(DuplicateRow),
EstimatedCompletionDate,
DuplicateValue
)
Currentrow () is not available