I am trying to develop a financial report that shows Balance sheet and Income Statement information. The problem is that I do not have separate tables for Assets, LIabilities, Revenue, Cost of Sales, Expenses. It seems that I will need to create measures that calculate these fields. However, there is no column for me to filter these areas only GL Codes. For example Revenue entries are coded to GL codes between 8000-8999.
How do I write a DAX Formula that returns the sum of a column ONLY if the GL Code falls between 8000 and 8999?
Revenue.pbix (3.0 MB)