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

SaumyaShetty's avatar
SaumyaShetty
Frequent Visitor
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.