Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm using the following function to give me the number of days between two dates:
Days to Process = 1. * ([RDOC_ORIG_POST_DATE]-[RDOC_SCAN_DATE])
In addition, via Modeling tab, I changed the 'Data Type' for the Days to Process field to "Whole Number". However, the value is still showing as a a decimal in the report. Not sure what I'm missing.
Solved! Go to Solution.
@mbs2016 You can simply go to query editor, then under Add Column tab select Add Custom Column as below. Finally change type of resulted column to Whole Number. Also ensure both date columns are of type Date.
You should also change the format of this data field into "Whole Number" and make sure the decimal place is 0. Then it will be rendered properly in visuals.
Regards,
@mbs2016 You can simply go to query editor, then under Add Column tab select Add Custom Column as below. Finally change type of resulted column to Whole Number. Also ensure both date columns are of type Date.