Correlating MB and KB.

[curtislholt]

Hello,

Sorry I'm a newbie with Power BI and I'm still learning. I'm looking to create a chart to represent backup sizes of different sizes along a time line to show any spikes or such things. There is a column with the data type in like MB and KB  and then another with the size in ie 156 (mb). Obviously when i put these into the graph BI can't understand that KB and MB are different values I imagine because I haven't told it so. Whats the best way of me getting this data into a graph without having make all the values the same format.

Sorry if this sounds confusing I've explained it the best I can.

Regards

Curtis

[Anonymous · Accepted solution]

Hi @curtislholt ,

As @amitchandak suggested, you could create a new value column with MB/KB type:

MB Size =
IF ( [Type] = "KB", [Value] / 1024, [Value] )

or

MB Size =
SWITCH ( [Type], "KB", [Value] / 1024, "MB", [Value] )

Or you could create measure instead like this:

KB Size =
IF (
    MAX ( 'Table'[Type] ) = "MB",
    MAX ( 'Table'[Value] ) * 1024,
    MAX ( 'Table'[Value] )
)

The final output is shown below:

Please take a look at the pbix file here.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@curtislholt , I doubt I have seen that in formatting. May convert MB to KB

You can create new column like

New value= If([Type]="MB" = [value]*1024, [value])

[curtislholt]

Hello,

Thanks for the help so far, I've created a new column and put this foruma into the top but I'm getting the following error...

DAX comparison operations do not support comparing values of type True/False with values of type Number. Consider using the VALUE or FORMAT function to convert one of the values.

Any advice on a fix?

Cheers

Curtis