Forum Discussion
Karthik12
Post Patron
Post PatronDAX filter support for customized date
Hello Team, Long time I am trying to get the solution for my requirement. I would like to get a table with customized start date and end date. Start date is 27.12.2022 and end date is always today...
Hi Karthik12 ,
You can create a calculated column as below to get the date range and apply the filter on the visual with the condition(Flag is not blank). Please find the details in the updated sample pbix file.
Flag = IF ( 'dates'[Date] >= DATE ( 2022, 12, 27 ) && 'dates'[Date] <= TODAY () - 1, 'dates'[Date], BLANK () )Create a calculated column
Apply visual level filter with the condition (Flag is not blank)
Best Regards
Hi Karthik12 ,
Please update the formula of measure [Plan_sum] and [Actual] as below and check if it can return the correct result. Please find the details in the attachment.
Plan_sum =
VAR _sumofplan =
SUM ( 'Plan sheet'[plan] )
RETURN
IF ( ISBLANK ( _sumofplan ) || _sumofplan = 0, BLANK (), _sumofplan )Actual =
VAR _sumofactual =
SUM ( 'Production sheet'[Pro Qty] )
RETURN
IF ( ISBLANK ( _sumofactual ) || _sumofactual = 0, BLANK (), _sumofactual )Best Regards
Karthik12Post Patron
Post PatronHi Anonymous Thanks.
Is it possible to replace Blank with 0 either plan or actual exists?