Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello! I need help writing a DAX formula that will allow me to use conditional formatting in a matrix to visually show when a rep was added to an account.
This is a matrix visual, and I'd like the formatting to roughly appear like the below:
This is the DAX formula I wrote:
I should have added that the 'Specialist' table contains several columns, but the two specific to the solution are: a Date column which is date format, and the column with the Period Sequence Number merged into the table in Power Query Editor.
The second table, 'Dim-Fiscal Calendar' is our fiscal calendar table that contains dates, and includes the Period Sequence Number in column FSC_PRD_SEQ_NUM.
These tables are joined 'Dim-Fiscal Calendar' 1:* 'Specialist'.
Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |