Forum Discussion
SUMIFS Statement
Super UserAnonymous best practice in PowerBI is to add date dimension in your model, there are many topics on how to add date dimension using DAX or power query. Once you have date dimension, all time intelligence related reporting becomes super easy with inbuilt time intellingence DAX functions.
Thanks, parry2k ! One thing I forgot to add, which I'll do in the OP, is that these calcultions will be looked up via another table, which is why I'm looking for these fields to be added as a calculation to then be related to another data set. Will your suggested solution still be able to help with this?
- parry2k
Anonymous you need to provide the full picture what you are trying to do. these measures will work depends how your data model look like. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490