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!

Casey's avatar
Casey
Regular Visitor
3 years ago

Hi Alan, 

Thank you for your reply, unfortunately, it did not work. I got The end of the input was reached message. I checked everything. 

 

Thank you