Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Multiple groupings for Column Headers

Is it possible to do Multiple groupings for columns in Power BI as shown in the image below. Are there any work arounds for this scenario? Sample Excel Sheet  Thanks in Advance!    
Need Help
Jveselka's avatar
Jveselka
Frequent Visitor
2 years ago

Ok, I'll see if I can do that. Now for another question.  I'm new to DAX so here is an example of the conditional column I created to group two columns.  I need the data in those two columns to be a calculation.  How do I add that in to DAX statement or is there another way.  

 

= Table.AddColumn(#"Unpivoted Other Columns", "Group", each if [Attribute] = "AppsPD" then "Life Apps" else if [Attribute] = "Apps" then "Life Apps" else null)

 

Example - 

APPS PD = Standards[AppsPD]*[TruncPeriod]/12
Apps1 = Standards[Apps]*[TruncPeriod]/12
 
MFelix's avatar
MFelix
Icon for Super User rankSuper User
2 years ago

Hi Jveselka ,

 

Not sure what you want to calculate, you refer dax however you send a code with M language (power query)

 

What is the final result you want to achieve?

  • Jveselka's avatar
    Jveselka
    Frequent Visitor
    2 years ago

    Grouped columns 1 and 2 and columns 4 and 5 need a calculation added. This is based on the period they select.  I have a column the strips off the month in the period. 202305 for the calculation

    TruncPeriod = MID('Standards'[Period],5,7)
    Apps1 = Standards[Apps]*[TruncPeriod]/12
     
    So using grouped column 1.  This needs to group the two columns and do a calc for each 

    Example - 

    APPS PD = Standards[AppsPD]*[TruncPeriod]/12
    Apps1 = Standards[Apps]*[TruncPeriod]/12
     
    I can do this using a table visual but not sure if it will work with the matrix visual.
     

     

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    2 years ago

    HI Jveselka 

     

    This should also work for a matrix, you may need to had a group column to your model in order to have everything correctly presented on the matrix, but shous work.