Forum Discussion

gelkins81's avatar
gelkins81
New Member
1 year ago

Week Over Week Change for Scorecards

Hi everyone!   New to the forums and looking for some help. I'm trying to have a WoW percent change scorecard underneath the main KPI scorecard, but having an issue with it returning the total r...
Need Help
gelkins81's avatar
gelkins81
New Member
1 year ago

Thanks for such a quick response!

 

I did try this solution, but am getting an error with the Earlier function:

 

Thoughts?  Sorry, I am somewhat new to Dax as I used Tableau at my previous agency and where I am now uses PowerBi.  I've learned a lot over the past 6 months, but there's a lot of different functions that I just don't know about yet.  Thanks!

bhanu_gautam's avatar
bhanu_gautam
Super User
1 year ago

Use DATE ADD instead of earlier 

dax
Oneview_Previous_Week_Impression =
CALCULATE(
SUM(Oneview[Oneview_Impressions]),
DATEADD(Oneview[Date], -7, DAY)
)

 

  • gelkins81's avatar
    gelkins81
    New Member
    1 year ago

    This is outputting the wrong amount:

     

     

    When I don't have the filter, the table outputs the correct amount on the row, but not at the total.  I need to figure out a way to output the row amount and not the total.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi, gelkins81 

       

      Can you provide some of the sample data and what you expect the output to be? Please remove any sensitive data in advance. How to provide sample data in the Power BI Forum - Microsoft Fabric Community

       

      Best Regards,

      Community Support Team _Charlotte

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