Conditional Formatting In A Table

[Anonymous]

Hello,

This is a very unusual request, but I am not able to replicate something that I have already done.

I have a small table with three fields (Unbilled-Recent; Unbilled vPM, Unbilled vPY). As you can see, the two last columns are conditionally formatted. I am not able to replicate this anymore in the new table (if I want to have the same with other values, it doesn't work). It works only if I add a new column with a Period (Month, Quarter, Date, etc.). But if I want to have only values as standalone columns like in this case, it doesn't work (i.e. there is no conditional formatting applied, so arrows do not show up).

Even if I am creating a new table, adding these three measures and try to format them conditionally once again, it doesn't work. 🙂 

Can anyone help - what is going on in here?

Below are the formulas:

Unbilled-Current-Month (same as Unbilled-Recent) = (calculate(sum('All BPOC Reports'[Unbilled]),filter('All BPOC Reports','All BPOC Reports'[Date01]=max('All BPOC Reports'[Date01]))))/1000  

Unbilled-Previous-Month =

VAR MaxDate = max('All BPOC Reports'[Date01])

VAR MyDate = calculate(max('All BPOC Reports'[Date01]),'All BPOC Reports'[Date01]<MaxDate)

RETURN

calculate(sum('All BPOC Reports'[Unbilled]),'All BPOC Reports'[Date01]=MyDate)/1000

Unbilled-Previous-Year = calculate(sum('All BPOC Reports'[Unbilled]),SAMEPERIODLASTYEAR('All BPOC Reports'[Date01]))/1000

Unbilled vPM = ([Unbilled-Current-Month]-[Unbilled-Previous-Month])

Unbilled vPY = [Unbilled-Current-Month]-[Unbilled-Previous-Year]

Here is a part of my dataset (it contains projects from 2020 and 2019):

REGION	PROJEKTNR	PROJEKTNAME	RISK	POC	DELTA	UNBILLED	DEFERRED	DATE01	PERIOD
VAST	123456	lalaland	0	ja	0%	0	11000	3/31/2020	03/27/2020
VAST	123457	whatever	9888	ja	0%	108000	600	3/31/2020	03/27/2020
VAST	771814	does	10000	ja	3%	1000	8060	2/29/2020	02/28/2020
NORR	555444	not	90000	no	5%	20000	40000	2/29/2020	02/28/2020
NORR	444311	matter	98666	no	10%	40000	13333	1/31/2020	01/31/2020
NORR	111441	at all	55000	no	22%	50666	50000	1/31/2019	01/31/2019