Forum Discussion
Show data between 2 Date Filters
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.
Hi Shadowestien ，
What does your data model look like and what are the inter-table relationships?
Best Regards,
Henry
I got 2 diferent tables for years and months and a relationship with the column on the main table.
Hi Shadowestien ,
According to your description, you want to filter the corresponding results in Measures_pdg by selecting the date range in Mesos and Anys?
Best Regards,
HenryYeah, 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"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.