Selecting Date basis date selected from Slicer

[pawan78]

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 

Z_Overdue Date = if(A[Due for Sales]<[Today],"Due","Not Due")

But want to create [Today] as dynamic date value basis selection from slicer (Date Field "B")

[pawan78]

Thanks 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 

[Bijen_Shah]

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!

[Bijen_Shah · Accepted solution]

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.

https://community.fabric.microsoft.com/t5/Desktop/sum-of-amounts-from-start-date-to-selected-date/td...

Did I answer your question? Mark my post as a solution!
Appreciate your Kudos!! Happy to Help!@pawan78