Forum Discussion
DAX: Filter one of two fields on same visual
We are atempting to show two values on a time graph by month. One value to show actual revenue for past months and the other value to show estimated revenue for future months. The issue is; when the ...
v-sihou-msft
Microsoft Employee
Microsoft EmployeeHi SALutions,
According to your description, you don't want to show actual values until current month has passed. Right?
In this scenario, you can add a calculated column to replace all Revenue in current month into '0'. Please refer to expression below:
=IF(table[month]=month(today()),0,table[Revenue])
Then you can include this calculated column into your chart.
Regards,
Thank you for your reply! You are correct, I do need to filter out current month's actual revenue. Your solution seems viable but to avoid some overhead with calculated columns, we would like to try and solve with an Actual Revenue measure by filtering the dates somehow instead. Any ideas?