March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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 using a measure, as my data is a SSIS connection adding calculated columns isn't an option (I'd be delighted if someone corrected me on this)
Is there any known workaround for this issue? I'd be open to making changes on the server side for the dataset if that would help.
Many Thanks,
Maurice
Hi @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
@Quinn92 you mean ssas?
in a live connection as far as i know you can't do this as its expected your data is modelled in the source, so thats the way to do it.
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
134 | |
91 | |
89 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
72 | |
68 |