Forum Discussion

curtislholt's avatar
curtislholt
New Member
5 years ago
Solved

Correlating MB and KB.

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. The...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.