Reply
Frequent Visitor
Posts: 5
Registered: ‎12-27-2018

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

Community Support Team
Posts: 7,656
Registered: ‎05-02-2017

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.
Frequent Visitor
Posts: 5
Registered: ‎12-27-2018

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

Frequent Visitor
Posts: 5
Registered: ‎12-27-2018

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

Frequent Visitor
Posts: 5
Registered: ‎12-27-2018

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

Community Support Team
Posts: 7,656
Registered: ‎05-02-2017

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.
Frequent Visitor
Posts: 5
Registered: ‎12-27-2018

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
Community Support Team
Posts: 7,656
Registered: ‎05-02-2017

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.