add a calculated column to the Date Table

[Anonymous]

Hi,

I need to add a calculated column to my date table to show 1 if the date = 2020.01.01 and if the date is = todate.The purpose is i need to show in my water fall chart x axis like this,

so im planning to make  a column to the date table and pick only "1" in a measure and place the measure into the x axis.Can anyone help me on this?

Thanks

Mish

[Anonymous]

@Anonymous 
I do not think make 1st jan and today = 1 is necessary.

Please see this doc to learn how to use Waterfall chart in power bi. To get the visuals link the image you need to put the date in the Category(x-axis) and sales in the Values(Y-axis), and add the breakdown column. You can also find a lot videos on YouTube if you search Power bi waterfall.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous ,

not very clear

a new column like this

if([Date] =date(2020,01,01) || [date] =Today() ,1,0)

or

if([Date] >=date(2020,01,01) || [date] <=Today() ,1,0)

[Anonymous]

Hi @amitchandak 

1st formula is working for me.

Thanks

Mish

[mhossain]

@Anonymous 

So what's the challenge in creating a calculated column in your date table? You can either do it in Powerquery or in DAX environment, powerquery will be preferable, try to create ther a calculated field.

Are you facing the challenge in creating waterfall chart? Please explain more.

[Anonymous]

Hi @mhossain ,

I got a calculated column to show january 1st as 1 and todate as 1.Now i need to use this as X axis in waterfall visual as i have attached a screenshot in my original post.Is there a way to do this in the visual?

Thanks