Forum Discussion
How to calculate Forecast accuracy
Community ChampionThese links from SQLBI may be of some help:
http://www.daxpatterns.com/handling-different-granularities/
http://www.sqlbi.com/articles/budget-and-other-data-at-different-granularities-in-powerpivot/
There is also a good example on pp 378-381 of The Definitive Guide to DAX by Russo and Ferrari if you can get your hands on that book.
Thanks for the tip. Looked it through but I can't see anything that would help me. Most things are about measures, and from what I understand I should be using columns to be able to evaluate rows individualy.
Glad to receive any further insights or tips!
- dedelman_clng
A measure can be evaluated row by row if your visualization is used correctly (matrix/table with the row identifiers as the rows).
Hi again,
Do you think you could elaborate based on the two sample pictures? I'm not sure how to get to the next step even though I've been trying to read through various postes as well as the links you provided. I'm rather new at DAX as you probably understand at this point :)
- dedelman_clng
What I mean by a matrix/table using a measure as a column is like the following:
TYTDRunningUpTime and RDT Hours are both measures. By putting Date and System as the rows, the measures essentially become columns in that visual. So once you follow the instructions through the patterns linked about, you can use your new measures in any of your visuals.