Forum Discussion
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 want to create visuals with the other dates in and be able to title them :-
| If this is todays Date | |||||||||
| Tue-04/01/2022 | Wed-19/01/2022 | Mon-24/01/2022 | Wed-26/01/2022 | Fri-28/01/2022 | Tue-25/01/2022 | Thu-27/01/2022 | Tue-25/01/2022 |
Also, using sql the online service just acesses the sql database via the gateway, will an excel sheet work the same way ?
Any help greatly appriciated
Ben
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
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 ?
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
