Power BI dataset not updating with DAX function

Hello mlin3 

okay... this is not DAX, this is just a simple Excel-formula.

Power BI is reading the current stored data, so with the data when you saved the workbook the last time.

This means the formula are not recalculated when you refresh Power BI. There are two solutions

A) Before refreshing Power BI you have to open the workbook as well

B) Read data without formulas (at least that are calculated dynmically like your date-formula) from Excel and reproduce the formulas in Power BI

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

Hi mlin3 ,

Just like what Jimmy801 mentioned, you need to create a calculated column in Power BI Desktop, not in the Excel workbook.

Reference: Tutorial: Create calculated columns in Power BI Desktop

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.