To convert the Tableau Calculated field to PBI DAX

[asdf1608]

The Tableau Calculated Field is

if DATETRUNC('week', [Date]) < DATETRUNC('week', Date])

then 0

else zn([column1]) + zn([column1])

How do I get Datetrunc in power BI Dax

Help in this is needed.

Thanks in advance

[Anonymous · Accepted solution]

Hi @asdf1608 ,

Please try this:

Column =
IF(
    DATEDIFF('week', [Date], [Date].[Date]) < 0,
    0,
    IF(
        ISBLANK([column1]),
        0,
        [column1] + [column1]
    )
)

You may find it helpful to refer to similar posts:

Please convert the below Tableau Expression to Dax... - Microsoft Power BI Community

Replicating Tableau Calculated Formula - Microsoft Power BI Community

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.