Create Dummy Data within a Table

[quincy_p]

Hi all - I am having a problem. I am trying to build a tool that will show us our planned services on specific assets.

The way we do this is via Work Orders and their Scheduled Date that are linked to a Product - however not all Products have an existing work order yet. Is there a way I can fabricate dummy work orders where they do not exist and populate the date based off of other criteria?

We could have a table like this with the relevant fields - not the tables are related by these 2 field:

Work Orders [Component] Many - 1 Covered Products [Id]

Product [Id]	Work Order [Name]	Work Order [Scheduled Date]
A12345	WO-12345	03/12/2025
A12345	WO-67890	09/12/2025
A67890	WO-23556	08/15/2025
B12345
C12345

In this scenario - could I create a new column in Work Orders where if Work Order name <> BLANK then return Work Order Name, otherwise create a unique Id and add a schedule date based off other criteria?

There would need to be an additional step to create mutiple lines for each product as they will have multiple services planned in the future, but that is a question after if this is possible.

Thanks!

[v-zhangtin-msft]

Hi, @quincy_p 

Have you solved your problem yet? If not, can you provide example files and what output you expect?

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,

Community Support Team _Charlotte

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

[Akash_Varuna]

Hi @quincy_p Yes, it is possible to create dummy work orders and populate Try these please 
Check for Blank Work Orders: Use a calculated column to assign dummy work orders for blank values.

Work Order [Name] = 
IF(ISBLANK(WorkOrders[Work Order Name]), 
   "WO-Dummy-" & WorkOrders[Component] & "-" & RANKX(ALL(WorkOrders), WorkOrders[Component]), 
   WorkOrders[Work Order Name])

Assign Scheduled Dates: Add a calculated column to generate dummy dates if the work order is blank.

Work Order [Scheduled Date] = 
IF(ISBLANK(WorkOrders[Work Order Name]), 
   DATE(2025, 1, 1) + MOD(ABS(HASH(WorkOrders[Component])), 365), 
   WorkOrders[Scheduled Date])

If this post helped please do give a kudos and accept this as a solution
Thanks In Advance