Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)

How can I have a calendar, one table occupied with the date and another table occupied with the predicted date 

ReportRange = IF(DATESBETWEEN (Calendar[SQL_Date], (TODAY()-7), (TODAY()+7)),1,0)

No syntax error

I have tried with it and no syntax error,but when I click ok I got a warning,How can I resolve it?

1 Answer

0 votes
by (22.5k points)
edited by

Under filter, open date filter and choose advance filtering and create a logic

enter image description here

Use a slicer between to and from the list

enter image description here 

Check the Power Bi Training  provided by Intellipaat 

Related questions

0 votes
1 answer
asked Feb 10, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
asked Jan 13, 2021 in BI by Chris (11.1k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

29.3k questions

30.6k answers

501 comments

104k users

Browse Categories

...