Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |