Forum Discussion

AAbdelkader's avatar
AAbdelkader
Helper I
9 years ago

data modeling with multiple format

Hello,   please, I need your useful ideas in how to preview a report which its value column have multiple formats. I ask that's the best data modeling to be able getting visual reports.   in reca...
Show and Tell
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi AAbdelkader,

 

From my point of view, I don't think it is a good practice to put different formats data into a single column. So I would suggest you unify the formats for the column to Decimal Number type in this scenario. The percentage(80%) and integer(66) type data is easy to be changed to decimal number type. For the Time(0:11:00) type data, you can convert it to seconds or minutes first, then change it to decimal number.:smileyhappy:

 

The formula below to create new calculate column to unify the formats is for your reference.

Unified Column =
IF (
    Data[Metric Name] = "AHT",
    MINUTE ( Data[Sup Total] )
        + SECOND ( Data[Sup Total] ) / 60,
    VALUE ( Data[Sup Total] )
)

 

Regards