Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

How to find lower bound value from measure when compared with another measure

Hi, How to find the Lower Bound value of a measure in Power BI from a Visual.  Suppose I have a "line and clustered column" visual where I want to find the expected time and cost the project ne...
General Comment
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, 

I have attached the sample file where it is interlinked with multiple measures, except "Date (bins)" Everything is a measure in my actual report file and I have created how those measures are created by commenting them in the file.
Is there any way that we can achieve the nearest lower value of the "Sum of ***bleep** Actual" in the visual?

Note: Here I cannot upload the sample file since I don't have an option to share it. Can you help me how to share it?



  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, Anonymous 

    You can use Google Drive to share links to pbix files with no sensitive data (please set up access without a login account).

    Best Regards,
    Yang
    Community Support Team

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi, Anonymous 

        I have checked your pbix file, but there is no Measure in the visual object as described in the title, how do you find the minimum value, you can describe your requirement and implementation logic in details.



        Best Regards,
        Yang
        Community Support Team