Forum Discussion
Solved
Create Dummy Data within a Table
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 link...
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
Hi quincy_p,
Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.
If the response addressed your query, kindly mark it as Accepted Solution and click Yes if you found it helpful — this will benefit others in the community as well.
Best regards,
Prasanna Kumar