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 

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
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 

 

 

Dev_Pat's avatar
Dev_Pat
Frequent Visitor
5 years ago

Hi Kim,

 

Thanks for quick revert.

I'm getting an issue saying "A table of multiple values was supplied where a single value was expected".

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

1. Market

2. Category

 

Could you help in modifying the current dax please?

 

A great thanks for your help.