Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 minus 1 day (Start date is fixed and end date is dynamic like today minus 1 day)
Pbix file link :
Solved! Go to Solution.
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 ()
)
Best Regards
@v-yiruan-msft Thanks you so much. It working fine.
Small issue if we apply for a large number of data, so many blanks in plan and actuals columns. Is there any measure to hide it?
If Plan and Actual both Zero or blank, can we hide it?
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
Have you tried this table expression already?
Hi @ppm1 Thanks !
I am new to DAX . started learning that one. also, Never tried before expression. I am bit diffcult to catch this expression like where to apply. Can you please apply in the pbix file and revert?
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 ()
)
Best Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |