James218Regular Visitor7 years agoSolvedDAX Novice Need Help I'm fairly new to DAX and Power Bi. I'm trying to come up with a formula that if the Splicing Date is > 4 days from then Turnover date or blank then the Turnover Date row will turn red. Any help wo...Show Moreparry2k to James2187 years agoJames218 can you make sure data type for your columns is date.
parry2kSuper User7 years agoJames218 add a calculated column for color and use that as background in conditional formatting. KPI Color = IF( 'Table'[Turnover Date] == BLANK() || Datediff( 'Table'[Turnover Date], 'Table'[Splicing Date], DAY ) > 4, "Red" )
James218Regular Visitor to parry2k7 years ago Thanks fo ryour help parry2k . Still having a little trouble. I'm getting this error and trying to figure out what's wrong. Thanks fo ryour help parry2k . Still having a little trouble. I'm getting this error and trying to figure out what's wrong.
parry2kSuper User to James2187 years agoJames218 can you make sure data type for your columns is date.James218Regular Visitor to parry2k7 years agoparry2k Thanks for your help that was the problem.
parry2kSuper User to James2187 years agoJames218 can you make sure data type for your columns is date.
Related contentNewbie help - best option for novice ETLSlicing whole model by date table, novice dax issuesM Novice QuestionNovice Data Modeling AdviceHelp for a novice please
