Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
dancarr22
Helper V
Helper V

Possible to create a dynamic table and see the results?

Hello,

 

I am trying to create a financial calculation (XIRR) in PowerBI.  To do so, I must first UNION together several calculated fields and other table results.  The issue I am encountering is I can't see the results of the calculated, dynamic table before passing it into the XIRR calc.  And the XIRR calc is not returning correct values so I need to see the dynamic table results first.  How can I see the results of 'transTableFiltered' so I can see what the results are being passed into the XIRR calc?  Thanks Dan

 

VAR transTable =
UNION(
--Get the beginning MV
 SELECTCOLUMNS(BEGINDATE_TABLE,"TransactionDate",BeginDate, "Amount", [_XIRR_Leveraged_BeginAdjustedMarketValue]),


--Get any transactions during the period
SELECTCOLUMNS(IRR_TABLE,"TransactionDate", XIRR_Lookup[TransactionDate],"Amount", XIRR_Lookup[Amount_WithMultiplier]),

--Get the ending MV
 SELECTCOLUMNS(ENDDATE_TABLE,"TransactionDate",EndDate, "Amount", [_XIRR_Leveraged_EndAdjustedMarketValue])

)


VAR transTableFiltered = FILTER(transTable, ISBLANK([Amount])=FALSE() && ISBLANK([TransactionDate])=FALSE())

 

 

 
1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey @dancarr22 ,

 

I use the DAX function TOJSON a lot to inspect the content of a virtual table when the measure is more complex. This article describes how TOJSON works: TOJSON – DAX Guide

 

Hopefully, this helps to tackle this challenge.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

4 REPLIES 4
Ashish_Mathur
Super User
Super User

Hi,

What happens when you click on New Table and put the formula there?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Thanks @Ashish_Mathur - I tried that but it is not 'dynamic' and does not update based on constantly changing parameters which is what is needed.

TomMartens
Super User
Super User

Hey @dancarr22 ,

 

I use the DAX function TOJSON a lot to inspect the content of a virtual table when the measure is more complex. This article describes how TOJSON works: TOJSON – DAX Guide

 

Hopefully, this helps to tackle this challenge.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Thanks @TomMartens - this helps!  I will review the JSON results and debug from there.  Appreciate your help with this.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.