[VinayG1984Participant Started: 0Replies: 3Total: 3]

Hi Tom,

I haven’t had a chance to look at the link you recommended. Will check that over this weekend and get back to you on the same.

 

Thanks for your help.

Regards,

VinayG

 

 

 

[VinayG1984Participant Started: 0Replies: 3Total: 3]

Hi Tom,

Thank you for looking into this. Yes, the model is extremely slow with larger dataset. Not just while refreshing, even if a user changes a filter selection to view the cashflows for their division it would take 10-15 seconds (even more) for each filter to get refresh and display results. Which is not very useful.

And apologies for such a complicated explanation of the model working. Wasn’t sure of how to explain in easy words.

Ok, If I had to do this in SQL environment I would have used 1st Self Join to create a matrix and 2nd self join with subquery to gross up the pattern replicated for each year to 100%.

Is there a way we can do self join with same table & self join with subset/summarized table using DAX efficiently and faster than what I am trying ??

I know you have already mentioned that your area of expertise is in different stream than what I’m asking. Would appreciate if you could please route this query to someone (OR guide me who to reach) who can help on this one ??

 

Regards,

VinayG

 

 

 

 

[VinayG1984Participant Started: 0Replies: 3Total: 3]

Can anyone help me with this exercise. Please let me know if you need more details around this.

 

Regards,

VinayG

[Author]

Posts