Forum Discussion

RyanBrantley's avatar
RyanBrantley
Frequent Visitor
6 years ago
Solved

Duplicate Visualizations, Different Behavior

I literally copied a visualization and used different data sets with identical field and data structures, but I'm getting a different outcome in the visualization.   We're pulling our Azure and AWS...
Need Help
  • RyanBrantley's avatar
    RyanBrantley
    6 years ago

    Jeez - nevermind, just answered my own question with this post.  Will leave for posterity in case anyone needs it for reference:

     

    DATEADD('DateTable'[Date].[Date], -1, MONTH)

    Was the issue in the AWS calculation.  Thought I had removed it, but apparently not.  For whatever reason the [Date].[Date] vs just [Date] will evaluate current month.... 

RyanBrantley's avatar
RyanBrantley
Frequent Visitor
6 years ago

Jeez - nevermind, just answered my own question with this post.  Will leave for posterity in case anyone needs it for reference:

 

DATEADD('DateTable'[Date].[Date], -1, MONTH)

Was the issue in the AWS calculation.  Thought I had removed it, but apparently not.  For whatever reason the [Date].[Date] vs just [Date] will evaluate current month.... 

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
6 years ago

Hi RyanBrantley ,

 

Thank you for your sharing, I'm sure it will provide reference for many people,. I suggest that you mark your replies as answers so that people can search for this post faster.

 

Best Regards,

Dedmon Dai