Forum Discussion
YTD For Two Dates
Hello, I hope there is someone who could help with this. I have two fact tables. Table 1 contains Work Order (Integer), WO Created (date) and Order Intake (decimal), Customer (text): W...
this is my bad, I was referring to the wrong table, apologies! the issue has been solved.
Anonymous , looking at data , WO Created has a timestamp. And was expecting that to be wrong unless you create a date column and joined with that.
Check if the period (date in Work Order ) has timestamp .
if so create a date and then join with date of date table and try
period date = [period].Date
this is my bad, I was referring to the wrong table, apologies! the issue has been solved.