Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

add a calculated column to the Date Table

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...
mhossain's avatar
mhossain
Icon for Solution Sage rankSolution Sage
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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