Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Quinn92
Regular 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 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

2 REPLIES 2
v-huizhn-msft
Employee
Employee

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

vanessafvg
Super User
Super User

@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.





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.