Idea Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content

XIRR DAX - Bug
Submitted by
Anonymous
on
02-06-2019
08:40 PM
Hi Team,
It seems like a PowerBI bug to me.
I'm trying to calculate XIRR using DAX with a certain dataset which is provided below. It works like a charm in excel but returns an error "XIRR function couldn't find a solution"
value | as_at |
-$11,632,091. | 30/06/2013 |
$11,632,091. | 30/06/2013 |
-$578,491,058.3 | 1/10/2013 |
$4,572,622. | 31/12/2013 |
-$4,572,622. | 31/12/2013 |
-$3,860,257. | 31/12/2013 |
$3,860,257. | 31/12/2013 |
$621,697,497.86 | 30/06/2014 |
$3,754,510. | 30/06/2014 |
-$3,754,510. | 30/06/2014 |
-$3,874,717.27 | 30/06/2014 |
$3,874,717.27 | 30/06/2014 |
-$66,879.73 | 30/06/2014 |
$66,879.73 | 30/06/2014 |
Can I get a resolution to this issue ASAP??
Thanks,
Hari T
See more ideas labeled with:
Comments
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Latest Comments
-
smpa01 on: We couldn't load your datamart
- BecC on: Turned off Callout Values in Card (New) Visual sti...
- catsamson on: SVG Image URL in Card (New) Visual is not working ...
- marvindo on: New Card Visual inadvertently switching on values ...
- Heather_Schramm on: Copying Table with Filters is Ignoring Filters
- DNilsson on: March 2025 Update - Error fetching data for this v...
-
AnGanjam on: Snowflake connector isn't showing views after Marc...
-
mattlee on: March 2025 update - Style preset error
- Eder_JG on: Conditional Formatting - Field Value not working a...
- jbongjbong on: Stretched App's Logo in Home Page "Recommended"
Idea Statuses
- New 7,881
- Needs Info 3,502
- Investigating 3,603
- Accepted 2,084
- Declined 38
- Delivered 3,964
-
Reports
10,154 -
Data Modeling
4,094 -
Dashboards
4,084 -
Gateways
2,103 -
Report Server
2,100 -
APIS and Embedding
1,951 -
Custom Visuals
1,772 -
Content Packs
521 -
Mobile
353 -
Need Help
11 -
Show and Tell
3 -
General Comment
2 -
Tips and Tricks
1 -
Power BI Desktop
1