cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vamsi789 Frequent Visitor
Frequent Visitor

No dax formula is working after december update

Hi

 

I updated my power bi desktop in december. When i opened my application no dax formula is workinga and data is empty

 

Can anyone help ,thanks in advance

 

 

 

powerbi sent.PNGsee there is no data shown and above is the dax formula

Thanks

Vamsi

7 REPLIES 7
v-jiascu-msft Super Contributor
Super Contributor

Re: No dax formula is working after december update

Hi Vamsi,

 

Can you verify the version of the Desktop? The latest is Version: 2.65.5313.841 (December 2018) for now. Please upgrade the Desktop if yours is lower than that. 

I'm afraid this isn't caused by the new version of Desktop. It could be caused by the new data. 

1. Please sort the columns to see if all the values are blanks. 

2. Please try to add a new column with the same formula to see what would happen.

3. Can you share the file? Please mask the sensitive parts first.

No-dax-formula-is-working-after-december-update

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
vamsi789 Frequent Visitor
Frequent Visitor

Re: No dax formula is working after december update

Hi

 

Currently my version is 2.65.5313.701 . I'LL try to update and get back to you.

 

Thanks

Vamsi

vamsi789 Frequent Visitor
Frequent Visitor

Re: No dax formula is working after december update

Hi 

 

I thought the error as version of power bi but the error is all my dax formulas are written in such a way that

last six months data = month(today()) - 6 like that but when it coming to january 2019 it is unable to getback the data in 2018.

 

can u suggest to get through that problem. Thanks in advance

 

thanks

Vamsi

vamsi789 Frequent Visitor
Frequent Visitor

Re: No dax formula is working after december update

Hi 

 

I thought the error as version of power bi but the error is all my dax formulas are written in such a way that

last six months data = month(today()) - 6 like that but when it coming to january 2019 it is unable to getback the data in 2018.

 

can u suggest to get through that problem. Thanks in advance

 

thanks

Vamsi

v-jiascu-msft Super Contributor
Super Contributor

Re: No dax formula is working after december update

Hi Vamsi,

 

There could be several ways. Please try out these solutions below.

1. 

 

CALCULATE(SUM('Table'[Value]), DATEADD('calendar'[Date], -6, MONTH))

2. 

 

 

CALCULATE(SUM('Table'[Value]), DATESBETWEEN('calendar'[Date], TODAY(), EOMONTH(TODAY(), -7) + 1))

If they can't help, please provide the formulas at least. A sample could be good.

 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
vamsi789 Frequent Visitor
Frequent Visitor

Re: No dax formula is working after december update

last six months = CALCULATE(COUNt(Sheet1[Number]),AND(month(Sheet1[Opened].[Date]) <= (month(today())-1),month(Sheet1[Opened].[Date]) >= (month(today())-6)))
 
see in the above i made the formula here it is not recognising the previous year 
 
Highlighted
v-jiascu-msft Super Contributor
Super Contributor

Re: No dax formula is working after december update

Hi @vamsi789,

 

I would suggest you create an independent date table and establish a relationship with the table [Sheet1]. Then you can use the time intelligence functions.

1. Create a Calendar table.

 

Calendar = calendarauto()

2. Try this measure. 

 

 

last six months =
CALCULATE (
    COUNT ( Sheet1[Number] ),
    DATESBETWEEN (
        'calendar'[Date],
        EOMONTH ( TODAY (), -1 ),
        EOMONTH ( TODAY (), -7 ) + 1
    )
)

 

Best Regards,
Dale

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

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 311 members 3,377 guests