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 September 15. Request your voucher.
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 |
---|---|
65 | |
62 | |
60 | |
53 | |
28 |
User | Count |
---|---|
181 | |
82 | |
67 | |
48 | |
44 |