Forum Discussion

ndna74's avatar
ndna74
Frequent Visitor
9 years ago
Solved

Format table to enable value comparison using DAX

Month Name Balance August Loan A 1000 August Loan B 2000 August Loan C 2500 August Loan D 1500 August Loan E 3000 September Loan A 1100 September Loan B 2000...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi ndna74,

     

    >>Could you also show me how to show the change in value each month? For example, how to show that loan A has increased by 100 between August and September.

     

    For your requirement, I merge the month and name columns to create a detail name column.

    Formula: Table = SELECTCOLUMNS(Sheet2,"Name",CONCATENATE([Month]&"-",[Name]),"Balance",[Balance])

     

     

    Create a visual with new columns:

     

     

    Click on "..." button to modify the sort column:

     

     

    Regards,

    Xiaoxin Sheng

ndna74's avatar
ndna74
Frequent Visitor
9 years ago

Thanks that's really helpful.

 

Could you also show me how to show the change in value each month? For example, how to show that loan A has increased by 100 between August and September.

 

Regards

Nick

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi ndna74,

 

>>Could you also show me how to show the change in value each month? For example, how to show that loan A has increased by 100 between August and September.

 

For your requirement, I merge the month and name columns to create a detail name column.

Formula: Table = SELECTCOLUMNS(Sheet2,"Name",CONCATENATE([Month]&"-",[Name]),"Balance",[Balance])

 

 

Create a visual with new columns:

 

 

Click on "..." button to modify the sort column:

 

 

Regards,

Xiaoxin Sheng

  • ndna74's avatar
    ndna74
    Frequent Visitor
    9 years ago

    Thanks very much