Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

calculations based on different data granularity

hello guys,   i need some help to resolve my issue with data at diffrent granularity, I have prepared pbix with data model and test data, which you can find at below link: https://ufile.io/0846h  ...
Need Help
  • SaumyaShetty's avatar
    SaumyaShetty
    7 years ago

    Hi,

     

    Please check the file int the below link.Does this suffice your requirement.

    https://uploadfiles.io/

     

     

     

    Regards,

    Saumya Shetty

Anonymous's avatar
Anonymous
Not applicable
7 years ago

thanks for reply :) is there any other solution without using bi-directional relationships?

 

Moreover, there was an mistake in provided model, because beside Val column in Discount table there should be also percentages values.. sorry for that, I have already extended model and updated the desired result

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

The download link in your orogonal post does not work.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      7 years ago

      Hi,

       

      In the Discount table, the %val column should be a % column.  In your file, it is a text column.  In the Query Editor make that change and share the download link again.  Also, in a simple table, show the exact result you are expecting.