Forum Discussion
Dynamically update column based on date slicer on PowerBi
I am new to PowerBi and have questions regarding dynamic filtering based on datetime slicer . Say I have the following table: Based on the date range(TableDateTime) I select from the slicer in p...
v-danhe-msft: Appreciate the response.
Taking the example of your case :
say my datetime slicer is from : 3/8 to 3/20
and ApprovalNumber > 0 && TimesApproved > 1 the desired result would be the Max Rev = 4 .
But in case lets take the date range : 3/15 to 3/20
where you dont have any instance of (ApprovalNumber > 0 && TimesApproved > 1) the desired result would be Max Rev = 7
Hi kauschan65 ,
If let take the date range : 3/15 to 3/20, there is no row in ApprovalNumber > 0, I could not understand your condition: ApprovalNumber > 0 && TimesApproved > 1
If there is no data in ApprovalNumber > 0, why the desired result should be 7?
Regards,
Daniel He