Forum Discussion
Format table to enable value comparison using DAX
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
Hi ndna74,
Based on my understanding, you want to get the result of current month balance/ total balance, right?
If it is a case, you can follow below steps to achieve your requirement.
Table:
Measure:
Percent =
var currtemp= LASTNONBLANK(Sheet5[Month],[Month])
return
MAX(Sheet5[Balance])/ SUMX(FILTER(ALL(Sheet5),Sheet5[Month]=currtemp),[Balance])
Format the value to "%":
Create the visual:
Regards,
Xiaoxin Sheng
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
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
Thanks very much
