Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Different behavior on using DAX formulas on a single (live Conn.) dataset bound to another report



I found some strange behavior in using a seperated Dataset (as PBIX) with reports in another PBIX as a solution(1)  versus a solution(2) in which the dataset and reports are combined in one PBIX.


In the first solution(1), using the Quick measure Month over Month, PowerBI creates a measure with the formula

DATEADD('TenantProductActivity'[ContentDate].[Date], -1, MONTH) somewhere in it.
Opening the measure and PowerBI complains that the part 'ContentDate].[Date]' is incorrect and returns an error 'Parameter is not of the correct type' . Strangly the Measure (as long you don't try to change it) will give the correct values... 
Using the same construct in the second solution(2) PowerBi does not complain and the measure kan be edit and reloaded correctly.
Anyone with the same experience and found a solution ?
Super User IX
Super User IX

Re: Different behavior on using DAX formulas on a single (live Conn.) dataset bound to another repor

@bert_Natenstedt , avoid using .[Date], and try

DATEADD('TenantProductActivity'[ContentDate] -1, MONTH)

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors