Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have 3 columns which I ma taking from 2 tables.
Start date and end date from contract table
reqquestdatetime from workorder table.
I need count of workorders if my requestdatetime is lying in the range of startdate and enddate
I used -
Hi @niharikaavasthi ,
It seems that you are creating a measure and you can refer to user @smpa01 's suggestion to update your measure formula. Or you can refer to the solution in the posts below to correct your formula and check later to see if you get the correct value...
1. Create a calculated column replace with original measure
2. Use the aggregation
A single value for column 'Open_Date_Time__c' in table 'Problem' cannot be determined
If the above methods do not help you to get the desired result, please provide some sample data of the Contract and WO tables and your final desired result with specific examples and calculation logic. Also, is there any relationship created between these two tables? Thank you.
Best Regards
Hi,
Share some data and show the expected result.
@niharikaavasthi try this
_count =
CALCULATE (
COUNT ( WO[WO] ),
DATESBETWEEN ( WO[Date], MAX ( Contract[Start] ), MAX ( Contract[End] ) )
)
User | Count |
---|---|
98 | |
91 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |