Forum Discussion
hoggwildd
10 years agoRegular Visitor
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...
- 10 years ago
For the denominator, can you use:
Denominator = ABS((TODAY() - DATE(2016,11,30)) / 30)
hoggwildd
10 years agoRegular Visitor
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
10 years agoCommunity Champion
For the denominator, can you use:
Denominator = ABS((TODAY() - DATE(2016,11,30)) / 30)
- hoggwildd10 years agoRegular Visitor
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