Forum Discussion
Dax calc
Hi all,
I have a report where i need to highlight different time frames.
Could someone help me to get a dax calc which would use two dates within the dataset and analyse whether the second date is within 5 days of the first?
DAX formula - to highlight if Date 1 is comoleted within 5 days of Date 2.
And conditional formatting to add a red icon for dates over the 5 day period and green for within.
Hi, Anonymous
Add a measure like:
diff = DATEDIFF(MAX('Table'[Date1]),MAX('Table'[Date2]),DAY)Then apply it to the conditional formatting of Icons.
result:
Apply conditional formatting in tables and matrixes#add-icons
Best Regards,
Community Support Team _ Eason
1 Reply
Hi, Anonymous
Add a measure like:
diff = DATEDIFF(MAX('Table'[Date1]),MAX('Table'[Date2]),DAY)Then apply it to the conditional formatting of Icons.
result:
Apply conditional formatting in tables and matrixes#add-icons
Best Regards,
Community Support Team _ Eason