Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX Function not recognising measure as ColumnTable

Hi,   I'm new in DAX. I'm trying to create a measure to show in a card, volume sales for the previous month (current month is still live so its not a full month). I have found the below example fun...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 

    SUM functions accepts only column as its argument and does not accept a measure. To recalculate a mesure no need to use SUM just use

     

    Previous Month =
CALCULATE (
    [Physical Cases Direct Actual],
    PREVIOUSMONTH ( 'DateTime'[DateKey] )
)

     

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

Hi Anonymous 

SUM functions accepts only column as its argument and does not accept a measure. To recalculate a mesure no need to use SUM just use

 

Previous Month =
CALCULATE (
    [Physical Cases Direct Actual],
    PREVIOUSMONTH ( 'DateTime'[DateKey] )
)

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank You!