Calculate GB Using DAX in Power BI

Question

I have columns Like Date, ID, Total Space these are columns how to create a KB, GB Calculation.

Date: 22/03/2019

ID: 1, 2,3, 4

Total Space: 342.45 bn

Based above column how to create a dax caluculation?

Answer 1

Hi, @Vnk

You can go through this regarding DAX calculation on KB and GB:

Total Used Space =
VAR total =
    SUM ( Table1[Used Space] ) + 0
RETURN
    IF (
        total < 1024,
        FORMAT ( total, "#0.0# B" ),
        IF (
            total < POWER ( 2, 20 ),
            FORMAT ( total / POWER ( 2, 10 ), "#0.0# KB" ),
            IF (
                total < POWER ( 2, 30 ),
                FORMAT ( total / POWER ( 2, 20 ), "#0.0# MB" ),
                FORMAT ( total / POWER ( 2, 30 ), "#0.0# GB" )
            )
        )
    )

Preparing for Power BI exam? Check out Power BI Syllabus now!