Forum Discussion

adarshthouti's avatar
adarshthouti
Frequent Visitor
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, adarshthouti 

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, adarshthouti 

    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

    • adarshthouti's avatar
      adarshthouti
      Frequent Visitor
      2 years ago

      Okay, I can give you an example suppose if I have a table like below 

       

      Let us think I have a budget of $20 in ID = 1 and the lowest near value of that $20 in expenditure is $15

      So how to create a measure in order to get the value $15