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.
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 |
---|---|
85 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |