Divide values into randomly unequal parts using DAX

DAX DAX Calculations
1

How do I divide values into randomly unequal parts using DAX?

See the attached file for the Excel version.

EDNA_Random_Divide.xlsx (11.9 KB)

Split Yearly into monthly.pbix (113.7 KB)

Thanks!

2

DAX does have the RAND function and the RANDBETWEEN function, one of these should do the trick.

RAND - https://info.enterprisedna.co/dax-function-guide/rand/
RANDBETWEEN - https://info.enterprisedna.co/dax-function-guide/randbetween/

1 Like
3

Hi @Heather,

I am aware of the functions thanks, but how would I structure the Excel solution into a DAX formula?

Thanks!

4

please provide a mockup DAX file, so that I or another forum member (if I don’t get back to it right away) can be built to suite your situation.

5

I will put one together soon, thanks.

6

@Heather, here’s the sample file: Split Yearly into monthly.pbix (113.7 KB)

7

@powerbideveloper,

See if this does the trick:

image
image1118×556 37.2 KB

Key change:

Total Random Factor by Yr = 

CALCULATE(
    SUMX(
        'Random List',
        [Random Factor]
    ),
    REMOVEFILTERS( 'Date' ),
    REMOVEFILTERS( 'Yealy Sales' ),
    REMOVEFILTERS( 'Random List'),
    VALUES( 'Yealy Sales'[Year] )
)

Full solution file attached.

3 Likes
8

Thanks, @BrianJ, this is great!

1 Like