Forum Discussion
mrothschild
3 years agoContinued Contributor
MdxScript(Model) (4, 21) Error - Couldn't load data for this visual from IPMT in Measure
PBIX file is here: https://drive.google.com/open?id=1L0ocvMPMCNtYLA3nX3ZvxgZB6HaMW-eg
The error message I'm getting is as follows:
The Measure formula that's throwing the error is:
ipmt = IPMT(0.08/12,MAX('Fact'[Period]),120,200000,0,0)
I was trying to follow this YouTube step for step: https://youtu.be/hZBQKUbLofE?t=586
and unless my eyes are wrong, believe I've recreated the Measure formula exactly.
Expected result is a table that doesn't throw an "Can't display the visual" error and to recreate the end result in the YouTube video linked above.
Thanks!
the second argument cannot be bigger than the third.
1 Reply
- lbendlinSuper User
the second argument cannot be bigger than the third.