Forum Discussion

Shadowestien's avatar
Shadowestien
Frequent Visitor
4 years ago
Solved

Show data between 2 Date Filters

I want to show the data where the column "Termini" it's between "Termini Inicial" (Start Date) and "Termini Final" (Final Date).
General Comment
Need Help
Show and Tell
Tips and Tricks
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi Shadowestien ,

     

    Delete the relationship between the tables, and then try the following formula to put the value of measure into the filter on this visual to show the result as 1.

    If the problem is still not resolved, please point it out or provide test pbix file. Looking forward to your reply.


    Best Regards,
    Henry


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

Shadowestien's avatar
Shadowestien
Frequent Visitor
4 years ago

Yeah, I want to filter the results of the table "Mesures_PDG", specifically the column "Termini" of this table, (it's the DATE column).
By the 4 filters that are (Start_Month & Start_Year) & (Final_Month & Final_Year).
By those 4 filtres i can create Start_Date & Final_Date.

Finally I want to filter "Termini" by the date range between "Start_Date" & "Final_Date"

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi Shadowestien ,

 

Delete the relationship between the tables, and then try the following formula to put the value of measure into the filter on this visual to show the result as 1.

If the problem is still not resolved, please point it out or provide test pbix file. Looking forward to your reply.


Best Regards,
Henry


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