Tableau dateparse function into power bi

[jitendersingh]

Hi all, I am not sure if this is the right place to put this, I am converting a tableau file to power bi. in tableau i have a expression 

Tableau Expression:  DATE(DATEPARSE("dd.MMM.yyyy",[Reporting Day]+"."+[Reporting Month]+"."+[Tax Year]))
the above expression i want to convert to power BI . Can anyone help me in it.

Date Sample below:

[selimovd · Accepted solution]

Hey @jitendersingh ,

I don't know Tableau so well, but from the context I guess you want to create a date from the 3 columns.

Try the following calculated column:

Date Column =
VAR vMonthAsNumber =
    SWITCH(
        myTable[Reporting Month],
        "JAN", 1,
        "FEB", 2,
        "MAR", 3,
        "APR", 4,
        "MAY", 5,
        "JUN", 6,
        "JUL", 7,
        "AUG", 8,
        "SEP", 9,
        "OCT", 10,
        "NOV", 11,
        "DEC", 12
    )
RETURN
    DATE( myTable[Tax Year], vMonthAsNumber, myTable[Reporting Day] )

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic