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)

     

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

Thanks, data makes it so much easier!

 

Here is what I get with your data and a simpel Table visualization in Desktop. I added a line for myself in the WPB office.

 

 

This looks OK to me but I assume I am doing it one way and you another since you mention pivot tables.

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..."?

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    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

      WHOO HOO!

       

      THANK YOU, THANK YOU, THANK YOU!

       

      Never read or found anything about "ABS", obviously still have a LOT to learn.

       

      Have a wonderful day,

      HW