Forum Discussion

hoggwildd's avatar
hoggwildd
Regular Visitor
10 years ago
Solved

Two problems I thought would be easy.

Hello everyone,   As a self taught person with the book PowerPivot and Power BI along with what I can find online I get myself confused, so thanks for any help. I am trying to do 2 things:   1. I...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    For the denominator, can you use:

     

    Denominator = ABS((TODAY() - DATE(2016,11,30)) / 30)

     

     

hoggwildd's avatar
hoggwildd
Regular Visitor
10 years ago

That can get it done when I publish in Power BI, is there a way to get it to work in Power Pivot?

 

Any ideas how to write a measure that will show the amount needed each month to reach the goal?

 

Again, thank you very much for your time.

 

HW

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

Let me look at the other issue.

 

For Power Pivot, right click the pivot table and go to PowerTable Options, click the Display tab, click the checkbox for "Classic PivotTable layout..."?