Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

undefined

this dax is not showing right output : Adjustedcash = IF(ISBLANK('Fin'[input]),BLANK(),'Fin'[cash]), please help me to make it right
Need Help
  • quantumudit's avatar
    quantumudit
    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

quantumudit's avatar
quantumudit
Icon for Super User rankSuper User
1 year ago

Hello Anonymous 

Please provide more details about the issues you're encountering. You can share a sample of the Power BI report you're working on with anonymized data.

Without sufficient context, it's challenging to determine why you're not receiving the correct output.

 

Thanks,

Udit