Forum Discussion

Mseddi's avatar
Mseddi
New Member
3 years ago
Solved

HELP _ Including measure in calculated column

Hi guys,   I have 3 table : * Sales table including invoice date * collection table including clearing invoice date, net due date, Collection Period as calculated column (clearing date-Net due da...
DAX
measures in calculated columns
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Mseddi 

    Please try

    Average collection previous year =
    VAR InvoiceDate = 'Sales'[Date invoice]
    RETURN
    AVERAGEX (
    FILTER (
    'Collection',
    'Collection'[Date] <= InvoiceDate
    && 'Collection'[Date] >= InvoiceDate - 365
    ),
    'Collection'[Collection Period]
    )

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

AnthonyGenovese 

Of course not. This is a No CALCULATE solution which means no context transition. 

AnthonyGenovese's avatar
AnthonyGenovese
Icon for Resolver III rankResolver III
3 years ago

Yah, my bad. I was assuming you called a measure & it had an implicit calculate.

  • Mseddi's avatar
    Mseddi
    New Member
    3 years ago

    Thank you guys so much. It worked.

    the X is the key for the solution : Row context. ❤️