Some formulas in Tableau that I need in Power BI

[hkpowerbi]

Hi All,

I just registered here because I am stuck with some issues and formulas that I am trying to create in PowerBI.

In Tableau, I have the following formula:

MAKEDATE(2017,[Month],1)

How would I replicate that logic in Power BI in a formula?

Another Tableau formula:

IF [Month] <= [CurrentMonth] THEN
DAY(DATETRUNC('month',DATEADD('month',1,[Makeitdate]))-1)
END

The [Makeitdate] in the second formula is derived from the first formula I provided above. Your help would be greatly appreciated. Thanks!

[Anonymous · Accepted solution]

Looks like the equiv of MAKEDATE is just DATE( ).  The 2nd one... I don't know tableau, so I can't guess.  What does it do?

[Anonymous · Accepted solution]

@hkpowerbi,

Create the following calculated columns in your scenario and check if you get expected result. If not, please share sample data of your table and post desired result here.

Mareitdate = DATE(2017,Table1[Month],1)
AddOneMonth = DATEADD(Table1[Mareitdate],1,MONTH)
FirstDay Of Month = DATE(YEAR(Table1[AddOneMonth]),MONTH(Table1[AddOneMonth]),1)
NewColumn = IF(Table1[Month]<Table1[CurrentMonth],DAY(Table1[FirstDay Of Month]-1))

Regards,

[hkpowerbi]

Thank you all for the help. This got me started and I am playing around with it deeper now. I will feel free to post on here for further help. Wow, this community is very powerful!

[Anonymous · Accepted solution]

Looks like the equiv of MAKEDATE is just DATE( ).  The 2nd one... I don't know tableau, so I can't guess.  What does it do?