Forum Discussion

Griffin_BI's avatar
Griffin_BI
Frequent Visitor
2 years ago

RAND with PARTITIONBY

Hello,

I have a table with an ID column and three dimensions A, B and C. 

I would like to add a fourth column, a random number, evenly distributed throughout a partition of A, B and C.

 

Is this possible please?

Thank you.

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, Griffin_BI 

    You can create a Custom Column in PowerQuery and use

    =Number.RandomBetween(0,6)

     

    The numbers in parentheses are a range of the numbers you want to random

     

    Here is my preview in report view

    You will get a different number with each refresh.

     

    How to Get Your Question Answered Quickly 

    Best Regards

    Yongkang Hua

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