Forum Discussion
Anonymous
1 year agoNot applicable
undefined
this dax is not showing right output : Adjustedcash = IF(ISBLANK('Fin'[input]),BLANK(),'Fin'[cash]), please help me to make it right
- 1 year ago
Hello Anonymous
Apologies for the delayed reply due to the timezone difference. You can create the DAX measure as follows:
Adjusted Cash = IF(ISBLANK(SUM(SampleTbl[Cash])), BLANK(), SUM(SampleTbl[Input]))Below is the solution screenshot:
Important Consideration:
- Ensure that the "Summarize by" option for the "Cash" column is set to "None" if it hasn't been already.Here's how you can do it:
Best Regards,
Udit
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍
🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree
Anonymous
1 year agoNot applicable
quantumudit did you got a chance to look at it?