Single value in PBI

[DR2022]

Hi! What is the measure to select a single value from a table, such as a current month value or any month value without comparing or accumulating them?

[PhilipTreacy · Accepted solution]

Hi @DR2022 

You can use SELECTEDVALUE to get a single value but I'm not sure that is really what you want based on your description, it's a bit vague.

Can you please provide soem detail about what you are trying to do and provide sample data and example of the desired result.

Regards

Phil

[DR2022]

For example, a monthly sales table for a product. I wanted to create a measure to put on a card with only the most recent month's product sales. The most recent data value without sum or average