Forum Discussion

Kevin_Harper's avatar
Kevin_Harper
Icon for Helper I rankHelper I
5 years ago
Solved

Create dynamic monthly value and multiply value across each row of a table

Hello, I have 3 tables with columns:   Table 1 - Brokerdata salesperson, order number, margin, delivery date, customer. I have a measure called "Multiplier" which is ((Brokerdata.margin - Salesp...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Kevin_Harper 

    I think you can use All function in your Measure to make the Multiplier in the same Month equal to a single value.

    Could you show me your data model, and provide me your Measure for Multiplier Column?

    Or you can provide me with your pbix file by your Onedrive for Business. And this may make it easier for me to understand your require.

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

     

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

Kevin_Harper Sorry, having trouble following, can you post sample data as text and expected output?


Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.