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


August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors