cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ResearchDev
Helper II
Helper II

HasValue is equivalent to what?

I am trying to convert the below code to a PowerBI Paginated report. What is the best way? If Has value in (:Sample Date) then perform a DateDiff function using Days to count from the difference between 2 days of which one is the data enter during a parameter the user selected date

-----------------------------------------------------------------
if hasvalue ({?Sample Date}) then
DateDiff("d",ITIdtToDate({T_SMPL.SMPL_DT}),{?Sample Date})
else
DateDiff("d",ITIdtToDate({T_SMPL.SMPL_DT}),{@currentdate})

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User
2 REPLIES 2
ResearchDev
Helper II
Helper II

I use a query instead. Now when using the query in SQL developer it runs fine and show the number of days between but in report builder. I get a CAST Problem is the one in BOLD. 

ResearchDev_0-1658343469116.png

 



SELECT
T_SMPL.SMPL_ID,
T_SMPL.SMPL_MIX_ID,
T_SMPL.SMPL_DT,
TO_DATE(SMPL_DT,'YYYYMMDD') smpl_dt_disp,
CASE WHEN
T_SMPL.SMPL_DT IS NULL OR T_SMPL.SMPL_DT=0 THEN SYSDATE
ELSE TO_DATE(T_SMPL.SMPL_DT,'YYYYMMDD') END - sysdate Days_Between,
T_PCC.MIX_ID
FROM
SM_ADMIN.T_SMPL T_SMPL
INNER JOIN SM_ADMIN.T_PCC T_PCC ON T_SMPL.SMPL_MIX_ID = T_PCC.MIX_ID

amitchandak
Super User
Super User

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.