I face a problem of columns that should not be shown.
I analyse revenue over years.
for the past I only keep revenue.
but for current year I have Revenue, budget, revised budget.
As I want to calculate the ratio between revenue & budget I created such a measure. easy.
The problem is that there is no result revenue/budget for the past... & all columns are shown.
Can I avoid these EMPTY columns? ( RED in the attachment)
Anything related to PowerPivot and DAX Formuale
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest