Generating random dates between a time frame

Anonymous — Thu, 03 Nov 2022 14:50:55 GMT

Hi all,

I have a dummy dataset that does not have a date column, Is there a way of generating random dates between a time frame in Power BI?

Re: Generating random dates between a time frame

v-xiaosun-msft — Fri, 04 Nov 2022 03:27:17 GMT

Hi Anonymous ,

According to your description, here is my solution.

You can create a calculated column by using RANDBETWEEN function.

I made a sample for you to reference.

Column = RANDBETWEEN(DATE(2022,10,1),DATE(2022,11,20))

Final output:

Remember that the data type of the "column" should be "DATE" or "DATE/TIME".

Best Regards,
Community Support Team _ xiaosun

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