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

[adarshthouti]

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 needs to be finished and how much time it took to finish.

I have found this data point value with the help of data date columnHow to find this value as I don't have any column which matches this value

[adarshthouti]

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]

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

[adarshthouti]

Please check the link below

https://drive.google.com/file/d/12aAfaYNS7hISYYDnru6veu31ItsAZd-2/view?usp=sharing

[Anonymous]

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]

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

[Anonymous]

Hi, @adarshthouti 

In Power BI, you can use DAX to calculate the lower bound of a metric, which needs to be done in the context of your calculations, you can convert your visual object to a table, which makes calculations based on tables easier, or you can share a pbix file with no sensitive data that can help you solve the problem.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum