Forum Discussion

bhartsell's avatar
bhartsell
Frequent Visitor
10 years ago
Solved

Beginner YTD

Hello,    I've been using the cloud-based Power BI for several months, but I am moving to Desktop Power BI because I was told it could allow me to do some specific things I couldn't do online. I ju...
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    10 years ago

    Welcome to the Power in Power BI :)

     

    Measures are like little formulas you right.   Say  "Total Sales := SUM(Sales[Amount])"   they generally operate on a full set of rows, and return a single value.   (Add up ALL my sales... returning just the total).  The cool think is that they are super dynamic.  If you happen to split your data out by geography, you don't have to go write a Total Sales By Geography measure... your current Total Sales measure will "just work".

     

    I'd probably recommend you grab a book.  Rob Collie and Avi Singh... or Matt Allington's... both are great and will get your ramped up quickly.

     

    In your case, because you want to do some stuff based around "time intelligence" that will be of particular importance in your reading.  You will want a separate "calendar table" and create a "relationship" between these tables... and it will change your life.

kcantor's avatar
kcantor
Community Champion
10 years ago

bhartsell Here is a link with more information on YTD.

http://databear.com/2016/05/08/power-bi-tips-calculating-year-to-date-values/

I do agree with Anonymous regarding Rob and Avi's book. They explian DAX in easy to understand language. I will alsos econd the need for a date dimension table. It is necessary for DAX to create time intelligence functions such as YTD and MTD calculations as well as Last year calculations from the same data table.