Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, I have a matrix with information. I want to show the sales depending on what the user wants (month, trimester or year)
The column of the matrix should change depending on that:
This is what I actually have but it´s not working (I cannot add as a column in the matrix)
ATM =
IF (
ISFILTERED ( Periodo[Valor]) && HASONEVALUE (Periodo[Valor] ),
if(LASTNONBLANK (Periodo[Valor], 0 )="Año",
VALUES(Informe_Cadenas_Final[YearMonth]),
if(LASTNONBLANK (Table1[Valor], 0 )="Trim",
values(Informe_Cadenas_Final[YearMonth])
)
),
VALUES(Informe_Cadenas_Final[Mes])
)
Is there any solution?
Thanks!!
Hi @hnoriega,
I modified your formula, you can try it if it suitable for your requirement.
ATM = IF ( SELECTEDVALUE ( Table1[Valor] ) <> BLANK (), LASTNONBLANK(Informe_Cadenas_Final[YearMonth],[YearMonth] ), SUM( Informe_Cadenas_Final[Mes] ) )
If above not help, it will be help if you share some sample data for test.
Regards,
Xiaoxin Sheng
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
79 | |
61 | |
60 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |