Forum Discussion

vinayganit's avatar
vinayganit
Frequent Visitor
2 years ago
Solved

Date fields in Field parameter

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 lin...
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    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!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
vinayganit
Frequent Visitor
2 years ago

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