Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Br4yan
New Member

Obtener el valor de una medida - Get the value of a measure

Hola, muy buenos dias.

Tengo un problema y la verdad no se como podria solucionarlo, soy nuevo en power bi.
lo que quiero lograr es esto:

Br4yan_0-1645456484195.png

Tengo una medida que es "Dias liberaciones". Lo que hace es que me cuenta los dias de una fecha que esta por vencer o que esta cerca. Lo que quiero lograr es obtener el valor de los que estan por 30 dias que seria un mes. Y me gustaria que en un tarjeta me muestre cuantos 30 dias hay, si 1, 2 o 3. La verdad no se como podria hacerlo. 

Teniendo cuenta de que no puedo hacer una tabla o columna. Solo podria hacer con otra medida, pero no se como. 

Si no se entiende muy bien, me podrian comentar en que parte no se me entiende. Muchas gracias

------------------------------------------------------------------------------------------------------------------------------------------

Hi, good morning.

I have a problem and I really don't know how I could solve it, I'm new to power bi.
what I want to achieve is this:

Br4yan_1-1645457280868.png

I have a measure that is "Days releases". What it does is that it tells me the days of a date that is about to expire or is close. What I want to achieve is to obtain the value of those who are for 30 days, which would be a month. And I would like a card to show me how many 30 days there are, whether 1, 2 or 3. I really don't know how I could do it.

Given that I can't make a table or column. I could only do with another measure, but I don't know how.

If it is not understood very well, could you tell me in which part it is not understood. Thank you very much for your help


  

1 REPLY 1
v-stephen-msft
Community Support
Community Support

Hi @Br4yan ,

 

Do you want to calculate the days between dates?

You may try DATEDIFF function.

DATEDIFF(<start_date>, <end_date>, <interval>)  

 

Is it possible to provide some dummy data and expected results?

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.