Date fields in Field parameter

[vinayganit]

Can we use field parameter to select between 2 date fields which are in 2 different tables?Parameters are created and line chart is showing date range as well the value is being aggregated single line and parameter is showing text as type. 

[v-linhuizh-msft · Accepted solution]

Hi @vinayganit ,

@audreygerred , thanks for your reply about this case. I tried to create a sample data myself based on the user's requirement and implemented the result. Please check if there is anything that can be improved. Here is my solution:

1.Create two tables with different Date range.

2.Use date fields of two tables as parameters:

3.Create measures:

Date_Measure
=CALCULATE(SUM('financials'[Profit]),FILTER('financials',SELECTEDVALUE('financials'[Date])))

Date2_Measure
= CALCULATE(SUM('financials (2)'[Profit]),FILTER('financials(2)',SELECTEDVALUE('financials (2)'[Date])))

4.Create a line chart:

5.The final results are as follows:

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[vinayganit]

Thank you very much . Just a follow up qn please reply when you are free...i want last year and 2 year before actual values which is another table so I have to make measures in the same way without linking to the Datetable right. Anyway really appreciate your efforts

[audreygerred]

Hi! This video is great at describing how to set up using two different dates: https://youtu.be/pQ9eSnfAhnc?si=AhxJY-1PrrLw1Ptk

[vinayganit]

Hey,I really appreciate the effort,thank you but this is different from the context .