EXCEL FORMULA TO POWER BI DAX

[christianfcbmx]

Hi dear community...question...

How can I write translate this excel formula into a power BI Table (Is in spanish) I hope someone could help me out

I need to have the same result as in excel but into a table created in power BI.

Excel file I need to insert in a power BI Table (I dont need to upload that excel table...it must be write in a table in Power BI)

https://www.dropbox.com/s/14jgb4im5dtwfug/Months.xlsx?dl=0

[v-yuezhe-msft · Accepted solution]

@christianfcbmx,

Based on your uploaded Excel file, you have the following columns in the table.


You can create the following columns in the table.

FACTUAL = TODAY()-1

DIAACT = DATEDIFF(Table3[FINICIO],Table3[FACTUAL],DAY)-1+1

DIAACT* = IF(Table3[DIAACT]>Table3[DIAMES],Table3[DIAMES],Table3[DIAACT])

Regards,
Lydia