Forum Discussion

PowerBI87's avatar
PowerBI87
Frequent Visitor
6 years ago
Solved

Column to Calculate Year

Hi,   Can i please get help to write a function that will output the column in the right?   Company Product Year Output ABC Corp A 2017 First Year GHY Corp A 2018 First Year ...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi PowerBI87 

    try to create column

    Output = 
var r = RANKX(FILTER(ALL('Table'), 'Table'[Company] = EARLIER('Table'[Company]) && 'Table'[Product] = EARLIER('Table'[Product])),
'Table'[Year], , ASC)
var textRank = SWITCH(r,
1, "First",
2, "Second",
3, "Third",
BLANK())
RETURN
textRank & " Year"Q
collinq's avatar
collinq
Icon for Super User rankSuper User
6 years ago

Hi PowerBI87 ,

 

To help out I would have to understand how the output is being determined.  It is obviously not the Year = Output so what are the variables you are trying to use?

 

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!