Random Number per StartDate

[Anonymous]

Hi all,

I have a startdate in my model for Orders. I'm trying to get the EndDate by adding some random numbers to the Startdate.

My problem is, The orders have different stages in which i goes through. The RandBetween() function is applying random numbers for all of these stages. 

What i need is, the randbetween() function should only consider Column "StartDate" and generate random numbers for it.

Any Idea on how to get this?

[Fowmy]

@Anonymous 

Not very clear, can you provide an example?

Also, share the DAX formula that you used to create the column. 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

@Fowmy  

I have used Randbetween(20,400) to create random numbers.  The StartDate is actually from the datasource itself.