Forum Discussion
Solved
Calculated column without using the CALCULATE function
Hi, I'm still a newbie in PowerBI and I'm trying to get a data with the use of filters but no data was generated from the formula. For context, I have a (summarized) table with Month, Year, Type ...
Hello, gonna close this thread now since I found a case similar to mine:
I applied the solution and it worked. Thanks everyone!
crln-blue
Can ou try this measure:
MonthPastYear =
CALCULATE(
SUM('Table'[Current Total]),
FILTER( ALL('Table'),
'Table'[Month]=MAX('Table'[Month]) &&
'Table'[Year] = MAX('Table'[Year]) - 1 &&
'Table'[TYPE] = MAX('Table'[TYPE])
)
)
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
Hi Fowmy , thanks for the reply. I tried your suggestion but the data generated isn't right. It gives off only one measure across all rows, maybe because of the MAX function.