Forum Discussion

Marcox28's avatar
Marcox28
Icon for Helper II rankHelper II
8 years ago

SUM SALES WITH PROMO

I have a problem in calculating sales made with receipts with at least one product being promoted.   my sales table is   TVE_ID TVE_IdArticolo TVE_Price TVE_CodicePromozione TVE_IDScontri...
Need Help
Marcox28's avatar
Marcox28
Icon for Helper II rankHelper II
8 years ago

oh wow!
and then how do we solve it with these compatibility?
I generated a disaster here on the forum :-)

Anonymous's avatar
Anonymous
Not applicable
8 years ago

MArco,

 

I postred a solution today using a calculated table that will update with the data updates. It worked beautifully for me. You had one of the best people on the case and it seems the Desktop version is not capable of some new capabilities. That's why it's free!

  • Marcox28's avatar
    Marcox28
    Icon for Helper II rankHelper II
    8 years ago
    Hello
    thanks for the solution but it's not my chance because I have a dynamic connection to a tabular database behind power bi. I certainly do not have a power bi free but the pro version and license sql enterprise 2016.
    I have to find a solution without importing the data and creating new tables
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Marco,

     

    The calculated table wouolld be created within the BI report, not on your server. Try it. If it's incompatible Power BI will tell you it's no compatible with the data source (and ask to download the data so say no if you don't weant that). 

     

    However, there are limitations to such methods. Actually, some of the measures that were delivered here create "views" or tables in the back ground. MAybe that's why it's not working. However, Power BI delivers to me a message when something I created is not compatible with dynamic data and it says the data needs to be loaded. 

  • Marcox28's avatar
    Marcox28
    Icon for Helper II rankHelper II
    8 years ago
    for the amount of data I have to process, I can not use a dynamic connection. this mode does not allow me to create tables inside the
    .pbx
  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago

    They did just add a preview feature in July 2018 for hybrid models (both dynamics connection and imported/calculated tables) but it is in Preview so mileage may vary.