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
VAR _PO = SUMMARIZE(‘PO’,
VAR _PO_DAYS =