I am trying to calculate average days to issue PO, and I am creating dax for it. I wrote a dax to get virtual table to calculate days as PO table may contain mulitple lines, so I need to have distinct PO Number and dates. I have used “AVERAGE(_PO_DAYS[Days])” to calculate avg but its showing error. Could anyone help.
Attaching screenshot and DAX code for reference.
Below are dax that is working fine till tabe level, but when i use average formula on virtual table column, it gives error
EVALUATE
VAR _PO = SUMMARIZE(‘PO’,
‘PO’[PO Number],
‘PO’[PO Date],
‘PR’[PR Date]
)
VAR _PO_DAYS =
ADDCOLUMNS(_PO,
“Days”, DATEDIFF(
[PR Date],
[PO Date],
DAY
)
)
RETURN
_PO_DAYS