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

Highlighted
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 
 
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
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 59 members 1,222 guests
Please welcome our newest community members: