Forum Discussion

Casey's avatar
Casey
Regular Visitor
3 years ago
Solved

Sameperiod last year

Hi,    I am new to Power Bi.  I have uploaded a Spreadsheet with the following Columns   Day - Month - Year - Revenue per day - Customer   I have created a Slicer to switch between Customers a...
  • AlanFredes's avatar
    AlanFredes
    3 years ago

    Hi Casey,

     

    There was just a small error with the DAX formula and I was able to fix it.

    Also if you want the difference to calculate for the whole year you will need a separate date table with the complete months for 2023. I added it and added a new "Total Diff Full Year" measure to calculate for all of 2023.
    Let me know if you have any further questions.

     

    Link: Items Fixed.pbix

     

    Did I answer your question? Mark my post as a solution!

AlanFredes's avatar
AlanFredes
Icon for Resolver IV rankResolver IV
3 years ago

Hi Casey,

 

There was just a small error with the DAX formula and I was able to fix it.

Also if you want the difference to calculate for the whole year you will need a separate date table with the complete months for 2023. I added it and added a new "Total Diff Full Year" measure to calculate for all of 2023.
Let me know if you have any further questions.

 

Link: Items Fixed.pbix

 

Did I answer your question? Mark my post as a solution!