Forum Discussion

kcantor's avatar
kcantor
Community Champion
11 years ago
Solved

Create a measure/calculated field

Greetings, As a new PowerBI user, I am struggling wtih what is probably a simple DAX statement. Of course I have not successfully integrated this into PowerPivot either so all helap is appreciated. ...
  • Anonymous's avatar
    Anonymous
    11 years ago

    Hello,

     

    Create a measure with CALCULATE(SUM([Sales Totals]), SAMEPERIODLASTYEAR([DateColumn])), and then, calculate the variance and %.

     

    Vicenç Lahoz

Anonymous's avatar
Anonymous
Not applicable
11 years ago

Hello,

 

Create a measure with CALCULATE(SUM([Sales Totals]), SAMEPERIODLASTYEAR([DateColumn])), and then, calculate the variance and %.

 

Vicenç Lahoz

ngottier's avatar
ngottier
Regular Visitor
10 years ago

Is there any way to accomplish ^ when in direct query mode? Currently Power BI does not support PREVIOUSXXXXX, or LASTXXXX time look backs in direct query.

 

I would switch to import, but the data set is millions of rows and not really feasible to be an import.