The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Good day everyone,
I hope you can help me with the following formula dax, I have a matrix that I want to paint as long as the month of the column (MRP Resin [Attribute]) matches the month of the row (MRP Resin [Name of the Month])
Thanks a lot
Solved! Go to Solution.
Hi @Syndicate_Admin ,
You can use the following DAX formula to paint the matrix as long as the month of the column (MRP Resin [Attribute]) matches the month of the row (MRP Resin [Name of the Month]):
f=IF(MONTH([MRP Resin [Attribute]]) = MONTH([MRP Resin [Name of the Month]]), table[value])
This formula checks if the month of the column matches the month of the row. If it does, it returns "Paint", otherwise it returns an empty string.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Syndicate_Admin ,
You can use the following DAX formula to paint the matrix as long as the month of the column (MRP Resin [Attribute]) matches the month of the row (MRP Resin [Name of the Month]):
f=IF(MONTH([MRP Resin [Attribute]]) = MONTH([MRP Resin [Name of the Month]]), table[value])
This formula checks if the month of the column matches the month of the row. If it does, it returns "Paint", otherwise it returns an empty string.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
78 | |
74 | |
42 | |
32 | |
28 |
User | Count |
---|---|
104 | |
93 | |
52 | |
50 | |
46 |