Forum Discussion

jstanley1017's avatar
jstanley1017
Frequent Visitor
1 year ago
Solved

create column data from multiple rows

I have a dataset that consists of many applications that are grouped by what we call an SRU Name. (many to one relationship between App ID and SRU Name). I would like to create an SRU Tier, SRU RTO a...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    1 year ago

    Mine is a calculated column formula.  The EARLIER() function works only in a calculated column formula.

jstanley1017's avatar
jstanley1017
Frequent Visitor
1 year ago

I am getting an error when trying to use the SRU Tier or SRU RTO code.

 

Am I doing this wrong?

Irwan's avatar
Irwan
Super User
1 year ago

hello jstanley1017 

 

the code is for DAX, not PQ.

after you have your data in PBI, then create a calculated column and paste the DAX.

 

also, if you have custom sort for Resilience, then it might be better to do indexing by RANK or RANKX depend on what value you have in custom sort.

 

Hope this will help.

Thank you.

  • jstanley1017's avatar
    jstanley1017
    Frequent Visitor
    1 year ago

    I am getting an error from the EARLIER function.

     

    EARLIER/EARLIEST refers to an earlier row context which doesn't exist.

    • Irwan's avatar
      Irwan
      Super User
      1 year ago

      hello jstanley1017 

       

      as Ashish_Mathur mentioned, EARLIER works only in calculated column. You got that error because you put EARLIER in measure not calculated column.

       

      create a calculated column for 'SRU Tier' and 'SRU RTO' then use either my DAX or Ashish_Mathur 's DAX with changes based on your table and column name (either DAX should be fine depend on your preferences DAX).

       

      Thank you.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      1 year ago

      Mine is a calculated column formula.  The EARLIER() function works only in a calculated column formula.