In this what happens is for the blank cells which don't have records in the file the condition fails and it show light green even the month is not the current month screen shot as below can someone help me writing the dax for this one. ![]() Power BI Masterclass DAX, R and Gateways 7. ![]() The Power BI Masterclass Additional Tips and Tricks 5. Microsoft Power BI Masterclass Expand Excellence 3.Power BI Masterclass DAX, Excel And More 4. IF (Max(Month index) > Month(now) & Max(Year) = year(now), "Sky Blue", "Light Green") Power BI Masterclass beginners to advanced 2. However for certain month there are records in the excel file which is used for the matrix table values because of which it is blank so how do I write a measure for blank cells Now if the year is 2023 I need the current month which is february as green rest all other months as blue including the Row grand total. Now the condition required is if the year is between 2020 till 2022 I want the color of columns to be green including the Row grand total. Power BI is a collection of software services, apps, and connectors that combine to turn unrelated data sources into coherent, visually immersive, and interactive insights. ![]() I have a slicer for year & for NWA Numbers Microsoft Power BI is an interactive data visualization software primarily focusing on business intelligence, part of the Microsoft Power Platform. Urgent help !! I am writing a dax measure for a matrix table so the table has month in columns and Items in row will share the screenshot below for reference.
0 Comments
Leave a Reply. |