Grouping Year Data into whole numbers

[Anonymous]

Hi Experts

i want to group my DAX table in a similiar format to the table that is currently being produced in R. The table from R shows the values for whole years where my table shows values for each interval within the year (months). I do not need to show the time series as show in R happy to have the product name as per DAX Table.

R TABLE

DAX TABLE

linkhttps://www.dropbox.com/s/47fyhkj5euzw02q/Kaplan_Miers_v1.2.pbix?dl=0

[v-shex-msft]

HI @Anonymous ,

I'd like to suggest you add a calculated column round up your decimals values to whole number then use new column on matrix column fields.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi Xiaoxin

Any suggest on how to round the decimals values to whole numbers...

[v-shex-msft · Accepted solution]

Hi @Anonymous ,

You can try to add a calculate column with ROUNDDOWN function to convert your decimal values to whole number.

Rounddown =
ROUNDDOWN ( Table[Decimal], 0 )

rounddown-function-dax

Regards,

Xiaoxin Sheng