cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Super User I
Super User I

Re: DateDiff in Measure

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Microsoft
Microsoft

Re: DateDiff in Measure

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

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors