Forum Discussion

mcarangelo's avatar
mcarangelo
Frequent Visitor
2 years ago
Solved

Help with a simple calculation please

I apologize in advance, but all I'm trying to do is calculate the difference between 2 columns and display the result of the calcuation. I've searched documentation, user posts etc. and nothing that ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi mcarangelo ,

     

    Thanks for the reply from Anand24 .

     

    Maybe you can try to convert Direct Query mode to Import mode.

     

    On the status bar bottom right corner, there's a text that reads "Direct Query: On (Click Here To Change)", if you click that and pick Import, your model should start importing.

     

    Note that this is currently a one way trip. i.e., an Import Model cannot be converted back to DirectQuery.

     

    After I established the relationship between the two tables, it worked normally.

     

    If you have any further questions please feel free to contact me.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi mcarangelo ,

 

Thanks for the reply from Greg_Deckler .

 

This is sample data that I created myself:

SalesA

SalesB

100

80

200

90

300

110

400

280

500

340

 

Create a measure:

 

Measure = MAX('Table'[SalesA]) - MAX('Table'[SalesB])

 

 

The page effect is as follows:

 

The pbix file is attached.

 

You can share an image or file by uploading it to a cloud storage service (e.g. OneDrive, Google Drive) and sharing the link.

 

Please do not log in to your account in Power BI Desktop when uploading pbix files.

 

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

 

If you have any other questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

mcarangelo's avatar
mcarangelo
Frequent Visitor
2 years ago

I used the suggestion above (to create a measure) and encountered an error message: "This query contains transformations that cant be used for direct query. " I included a screenshot below.