Forum Discussion
Selecting Date basis date selected from Slicer
Hi
Want to create a calculated column which compares a date field "Due for Sales" with another Date Field "B" and returns the value (Not Due/Overdue) basis A<B .
I also want user to provide value to date field B. User can do basis selecting the date from slicer on field B
Please guide how to do the same ?
Am able to compare the Due for Sales with Today date as below
Hi pawan78
1. To create a dynamic date value filter you must create a calendar table which has the relevant dates to be filtered.
With this dynamic approach creating a static calculated column wouldn't be ideal.
2. Create measures similar to the below thread which will give you a dynamic due sales sum for different selections.
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos!! Happy to Help!pawan78
3 Replies
Hi pawan78
1. To create a dynamic date value filter you must create a calendar table which has the relevant dates to be filtered.
With this dynamic approach creating a static calculated column wouldn't be ideal.
2. Create measures similar to the below thread which will give you a dynamic due sales sum for different selections.
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos!! Happy to Help!pawan78Thanks a lot Bijen
This is helpful , also the issue is that i need to create a chart basis the data (# Deals basis Due / Overdue date) , but if i create a measure , i am unable to create the chart as below. (here Z_Overdue Date is Column)
Can you guide on same as well
Hi pawan78 ,
I think you can use measures in bar charts with Column Date on X Axis and Measure Values on Y Axis.
If you can share the specific issue you face on the chart or a pbix file would be easier to help you better.
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos!! Happy to Help!
