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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.