Forum Discussion
Adding filter (Conditional formatting) to table
Happy Friday I need some help adding a filter in a table. I have the table below with Manager's Name, Associates, ROle and Project Number. The conditional formating is showing Green Orange...
Could you please tell the formula for seasonality? only then we can write the DAX
HI
That's the thing. I don't know how to add that part.
The formula should say, if ROle "IPM" then
July = 3 CUID
Aug = 2 CUID
Sep = 2 CUID
Oct = 3 CUID
Nov = 4 CUID
Dec = 2 CUID
Jan = 5 CUID
Feb = 3 CUID
Mar = 4 CUID
Apr = 4 CUID
May = 4 CUID
Jun = 4 CUID
And if the ROle "IC/IPM" then
July = 1 CUID
Aug = 1 CUID
Sep = 1 CUID
Oct = 1 CUID
Nov = 1 CUID
Dec = 1 CUID
Jan = 3 CUID
Feb = 3 CUID
Mar = 3 CUID
Apr = 3 CUID
May = 2 CUID
Jun = 3 CUID
Full Capacity =
Switch( true() ,
Sheet1[Role] = "IPM", 3,
Sheet1[Role] = "IC/IPM", 4,
blank()
)