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.

amitchandak's avatar
amitchandak
Super User
5 years ago

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's avatar
curtislholt
New Member
5 years ago

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