Forum Discussion

Dev_Pat's avatar
Dev_Pat
Frequent Visitor
5 years ago
Solved

DAX for Year in Calculated Column

Hi Team, I need a help to develop a DAX as calculated column . Below is the detail requirement. Any help much appriciated.   I have data of last 4 year (2018-Jan to 2021-May) in rows shown below....
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

     

    2019 Volume CC =
    VAR _currentrowmonth =
    MONTH ( Data[Date] )
    VAR _resulttable =
    SELECTCOLUMNS (
    FILTER (
    Data,
    YEAR ( Data[Date] ) = 2019
    && MONTH ( Data[Date] ) = _currentrowmonth
    ),
    "@result", Data[Volume]
    )
    RETURN
    _resulttable

     

     

    Link to the PBIX file 

     

     

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

=sumx(filter(table,format(table[date],"yyyymm")=format(earlier(table[date]),"2019mm")),table[volumne])

Dev_Pat's avatar
Dev_Pat
Frequent Visitor
5 years ago

Hi Daniel,

Thanks for quick revert.

After using the dax I'm getting blank cell.

i think because I have two more column before date column.

1. Market

2. Category

 

Could you help in modifying the current dax please?

Thanks