Kevin Arnold

Data Solution Professional


  • Why did a simple model change break my report?
    During our DFW User Group meetings we open the floor to questions. During a recent meeting an attendee asked why his measure stopped working correctly when he only changed the model to sort a column. It was a fun exercise that took many of us too long to solve.   TL/DR Bottom line, be careful
  • Managing Report Level Measures
    During the Feb 27 Guy in a Cube live stream, I submitted a two-part question to gather thoughts on Report Level Measures. Q: When separating the model from report files, where is the best place to keep measures that are unique to the report? For example, conditional format, dynamic text boxes. 1 / 2 Q:
  • Projects within Months
    This post answers a question posted on the SQLServer Community slack #powerbi channel. I am trying to build this report where I have a start and end date for each record and chart out the values. Ideally, if the month is in between the start and end date I would grab that value and chart
  • Modeling Dates
    This post looks at different modeling techniques when working with dates. It is a topic covered quite a bit, but I still receive questions. I plan on using this post to help with those conversations. When your data has multiple dates, for example, Order and Ship dates, you have various options.   I will provide examples
  • DAX Use Relationship
    The question in the image below came from the Global Power BI User Group on Facebook. It seemed better to answer with a quick blog post to provide more detail. This example can be solved with multiple relationships between the FACT and DIM table. Only one relationship will be active, the others will require the

Hi, I’m Kevin Arnold. A data geek

Have a business data challenge? Let’s talk

Social media & sharing icons powered by UltimatelySocial