CALCULATION THAT RETURNS THE LAST MONTH ACCORDING TO THE CATEGORY

[Anonymous]

HI,

I wonder if anyone can help me in the following situation I have a category of documents and each document has status (A or B) I need to do a calculation that every last month shows all categories in a table and in the other months show only category A

EX: HOW IS IT                  

        

as it should show in the table in power bi

As April is the last month only he brings all categories A and B

[Anonymous · Accepted solution]

Hey @Anonymous ,

I think you get your answer from below link post.
https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/

Best Regards,
Nirav Prajapati.