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, get a free DP-600 exam voucher to use by the end of 2024. Register 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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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