Forum Discussion
Quinn92
9 years agoRegular Visitor
DateDiff in Measure
Hi - I'm trying to evaluate the number of days between the Today() function and several date data points in my dataset using the DateDiff. I'm unable to select these data points however when usin...
v-huizhn-msft
Microsoft Employee
9 years agoHi Quinn92,
SSIS is a platform for building enterprise-level data integration and data transformations solutions. Your resource data must be stored in database or other places, If you want to do it in Power BI, you need to upload the data into Power BI by "Get Date" function, please review this article. Then you can create a calculated column usinng DateDiff function.
If you want to get days between the Today() function and several date data points in your SSIS platform, you'd better post your thread to SSIS forum, I am not specific for SSIS, you can get professional support there.
Thanks,
Angelia