Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Compare Current Week vs previous X weeks - Service Desk Incidents

Hello, and thank you for taking your time to read this.   I am quite new to calculated columns and measures, but I have built similar reports in the past. however, Power BI and DAX is proving to be...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

Share the link from where i can download your Excel worbook with your formulas in there so that i can understand your logic.  Please also:

  1. Share a larger dataset
  2. Build a Calendar Table with a column of week numbers in there.
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    See attached.

     

    Let me know what you think. Of course, the solution to the problem in Excel might look stupid, but as I was explaining before. Thank you.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      4 years ago

      Hi,

      You may download my PBI file from here.

      Hope this helps.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Amazing! I'm just downloading so I'll come back with some comments shortly!