Forum Discussion

joeydeacan's avatar
joeydeacan
Regular Visitor
4 years ago
Solved

Getting various dates to display

Good morning all,   I hope you can help, Ive be using BI for a while now but always via sql.   I have an excel sheet where is have a few date fields, if the date in column a matches todays date i...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi joeydeacan ,

    According to your description,here's my solution.

    1.I create a sample.

    2.Create a measure.

    Check = IF(MAX('Table'[Column1])=TODAY(),1,0)

    3.Put column2 into a visual, put the measure into the visual filter and select the measure is 1, then the value which date is today in column1 will be filtered out.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

joeydeacan's avatar
joeydeacan
Regular Visitor
4 years ago

So basically what im trying to say, and not very well.

 

Can I display a box which will show, if column 1 = todays date then display column 3 ?

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    Hi joeydeacan ,

    According to your description,here's my solution.

    1.I create a sample.

    2.Create a measure.

    Check = IF(MAX('Table'[Column1])=TODAY(),1,0)

    3.Put column2 into a visual, put the measure into the visual filter and select the measure is 1, then the value which date is today in column1 will be filtered out.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.