Forum Discussion
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 line and parameter is showing text as type.
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 TeamIf 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!
4 Replies
Hi! This video is great at describing how to set up using two different dates: https://youtu.be/pQ9eSnfAhnc?si=AhxJY-1PrrLw1Ptk
Hey,I really appreciate the effort,thank you but this is different from the context .
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 TeamIf 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!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
