Forum Discussion

oliverblane's avatar
oliverblane
Icon for Helper III rankHelper III
4 years ago
Solved

Using a Date Table Slicer with a table that has dates outside Date Table range

I have a date table that includes dates from 1st March 2021 to the present date. I have a table of data that looks like the following: I am looking to use the Date column from my date table to...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Hi oliverblane ,

     

    Try to create a measure like below:

     

    Measure = calculate(count('table'[role id]),filter('table','table'[review date]>=min('date'[date])&&'table'[review date]<=max('date'[date])))

     

    If the problem persists, can you provide a sample pbix after deleting sensitive data.


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

     

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi oliverblane ,

 

Try to create a measure like below:

 

Measure = calculate(count('table'[role id]),filter('table','table'[review date]>=min('date'[date])&&'table'[review date]<=max('date'[date])))

 

If the problem persists, can you provide a sample pbix after deleting sensitive data.


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