Forum Discussion

Matteoss's avatar
Matteoss
Regular Visitor
4 years ago

Revenues variable

Hi there,    I have a model with three fact tables "Importi_2020" "Importi_2021" and "Importi_2022" all linked to a Calendar table.  I need to implement a "Revenue Variable" that changes its value...
Need Help
Matteoss's avatar
Matteoss
Regular Visitor
4 years ago

Thanks for your fast reply, 

 

I try to explain i little better what is my issue. 

It is like i have three sales tables one for each year (2020, 2021, 2022). I cannot append them since they have been implemented differently. What is the same is the final value of total sales for each month. 

I think the solution could be related to a variable that give me as output the correct sales amount linked to the three tables according to the year. 

I do not think the measures you give me can work in my case. 

Sound it reasonable for you? 

 

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    Hi, Matteoss 

     

    Can you provide some sample data or simple pbix files? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures.

     

    Best Regards,

    Community Support Team _Charlotte

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