Forum Discussion

Gazi_Sohan's avatar
Gazi_Sohan
Icon for Helper I rankHelper I
2 years ago
Solved

Need Help with Calculate

Hi guys, I am trying to calculate Net Income between 2 accounts (account numbers between 400000 and 957090), however I want the account number to come from the columns instead of hard coded. I tried ...
  • Gazi_Sohan's avatar
    Gazi_Sohan
    2 years ago

    Hey Anonymous 
    Thanks for your solution. Though it's working on the sample file but it didn't work out in our main file.

    I have tried my own way by using a pretty simple approach i.e. using selectedvalue function and it's working perfect in the measure and made it dynamic - 



    I have applied the same concept in the sample POC file that I provided for you (attached) - 


    and it's also working fine in the sample file - 

    But anyway, thanks for your help. I really appreciate it. You are a very talneted guy I must say.
    Hats off ðŸ’¥


    .pbix file with my dynamic measure - 
    https://drive.google.com/file/d/1jRhL9q_ytVP4OxSyjntFliLqdm_IXynP/view?usp=sharing

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Gazi_Sohan ,

 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please feel free to let me know.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.