Forum Discussion

HillUser1's avatar
HillUser1
Frequent Visitor
5 years ago
Solved

DAX Help: How to iterate a calculation over a single dataset based on a time period.

I am struggling to understand how I could perofrm this calculation within PowerBI/DAX.   Calculation: Create a weighted rating system to help our company rank customers. Our team has come up with a...
Need Help
  • HillUser1's avatar
    HillUser1
    5 years ago

    + Update:

     

    I will perform the required math outside of PowerBI (WinForm/VB.net) and write the calcuated values to a database.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

HillUser1 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

HillUser1's avatar
HillUser1
Frequent Visitor
5 years ago

I can not post a sample dataset becuase I dont know all the senstive fields and this PBIX combines multiple tables together. I created a sample table showing the calculation, but the issue is that sum for all the years or manually requires me to filter the table with a slicer.

 

Data Tables:

    Invoice Table (All invoices to sum total revenue)

    Work Order Table (All Quotes, Counts,

    Customer Table (Customer Name, ID, Address, Date Entered)

    

 

 

Sample Concept Table for Calculation