SQLTeam.com | Weblogs | Forums

Display for column with Int64 data type as result of direct query in powerbi

Hi All,

Can please help me with the powerbi issue?

I am creating a report to count an age that will be calculated using today date by default of by the slicer in DAX. Therefore, I need to use Dynamic M Query parameters. This is the article about it. Dynamic M query parameters in Power BI Desktop (preview) - Power BI | Microsoft Docs

This bind to parameter option only can work on the direct query in the power query. Which has restriction to use the data type transformation. Therefore, I need to specify the preferred data type at the beginning of column creation that is using my parameter (p_Created_Date). This parameter will be linked to the slicer using the binding to parameter option at DAX. The formulation of the new column is:

= Table.AddColumn(#"Reordered Columns", "Age", each (if [Closed] = null then p_Created_Date else [Closed]) - [Opened], Int64.Type)

The calculation result for this column in Power Query is:

image

The Age column of the first row will be displayed at DAX using card visualization but somehow the value become like this instead of 14.

image

Anyone know know what is wrong and how to fix this?
Thank you.

Susan

I don't know PowerBI, but I would guess it's this p_Created_Date. Looks like a date column instead of some sort of age calculation

What is your data source?