Forum Discussion

ColetonC's avatar
ColetonC
Regular Visitor
2 years ago

Reducing a value from a column by week in a DAX table

I am trying to show a reduciton in a projects budget each week by subtracting the weekly billed amount from the original budget amount. I currently have a summary table pulling in the weekly billed a...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

Why are you creating a DAX table?  Why are you not solving it with a measure?  Do you have a Date column?  If you are OK with a measure solution and have a Date column, then share the download link of the PBI file. 

ColetonC's avatar
ColetonC
Regular Visitor
2 years ago

I did try a measure initially but had trouble geting a reduction by week to be illustrated in a visual. There is a date column in the table with containing the expense data. (I have a calendar table that is connected to the dates in the expense table.) There is not a date column in the table containing the project data (budget). Here is the measure I tried 

 

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

    As requested earlier, share some data to work with and show the expected result.

    • ColetonC's avatar
      ColetonC
      Regular Visitor
      2 years ago

      Here is the result I am looking for 

      I have a PowerBI file I can now share but I am not able to share in this reply. What is the best way to share the PBIX file?

       

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

        Upload the file to Google Drive/One Drive and share the download link.