Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
86 | |
77 | |
70 |
User | Count |
---|---|
120 | |
108 | |
98 | |
83 | |
77 |