Mostrar solo los datos en una matriz donde el ultimo mes tenga datos

[Lushernandezf]

Tengo una matriz con %Dato (columnas) y producto (filas). Busco que se muestre solo los %datos donde el ultimo mes tenga datos. Ejemplo: muestre solo las filas de Producto1, Producto4, Producto6, Producto8 y Producto9.

[v-nmadadi-msft · Accepted solution]

Hi @Lushernandezf ,
Thanks for reaching out to the Microsoft fabric community forum.

To achieve your desired output, you need to create a DAX measure  which will output a Flag value of 1 when the required condition which is in your case having data for the last month.
You can use that Flag value to filter out the unnecessary data

Here is the DAX measure

Flag_August =

VAR HasDataInAugust =

    CALCULATE (

        COUNTROWS ( 'product' ),

        'Product'[Month] = "August"

    )

RETURN

IF ( HasDataInAugust > 0, 1, 0 )

Attaching the .PBIX file for reference.

I hope this information helps. Please do let us know if you have any further queries.
Thank you

[Lushernandezf]

Muchas Gracias! me ha funcionado, justo lo que necesitaba

[FBergamaschi]

You need to identify the last year-month in a column of the calendar table and then write a DAX measure to show values of the %Data measure only when the last year-month is in context. To implement this, either upload a pbix file in some cloud service and hsare the link here or please include in your answer, in a usable format, not an image, a small set of rows for each of the tables involved in your request and show the data model in a picture, so that we can import the tables in Power BI and reproduce the data model. The subset of rows you provide, even is just a subset of the original tables, must cover your issue or question completely. Do not include sensitive information and do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided and make sure, in case you show a Power BI visual, to clarify the columns used in the grouping sections of the visual.

Need help uploading data? click here

Want faster answers? click here