Forum Discussion

Vallirajap's avatar
Vallirajap
Icon for Resolver III rankResolver III
2 years ago

Days display values above today in the column visual

Hii All, I try to display the current month values(MAY) in days using a column chart.  In Dax, I return the output as a variable + 0. For example, _val + 0 will display the blank as 0. But it d...
data protection
Need Help
Show and Tell
Tips and Tricks
Alpesh's avatar
Alpesh
Icon for Helper I rankHelper I
2 years ago

You will need a calendar table and a relationship between your fact table date column and calendar date column. Pleaes search online if you don;t now how to create a simple calendar table.

In the calendar table you will need a Day Offset column. If you can't find a calendar table online with this, create a new Custom Column on the calendar table with the formula: 

Day Offset = (TODAY() - [Date]) * -1
 
This will create a column where today's date will be 0, yesterday will be -1, tomorrow will be +1 etc....
 You should then be able to filter: Day Offset >= 0 which would have from today and all previous dates