Forum Discussion

Rajesh_Konda's avatar
Rajesh_Konda
Frequent Visitor
3 years ago
Solved

Subtract cost between product and dates

Hi All,   How can i Subtract cost bet ween dates based on product.   Ex:  Cost ServiceName Date 20 XYZ 04-04-2023 30 ABC 05-04-2023 50 XYZ 05-04-2023 10 ABC 03-04-2023 ...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    You don't need separate queries.

     

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

You will have to explain what you want the Total to display. It may not even be required/meaningful in your case.

Rajesh_Konda's avatar
Rajesh_Konda
Frequent Visitor
3 years ago

Sorry  lbendlin ,  I am actually new to power BI. I thought of displaying Total results in a  visuals(card, bar graph, pie) but when i add Calculated dax column to any visuals the results shown are incorrect(compared results in DB). But on the matrix table the values are shown accurate for column. I Appreciate your help Thanks a lot.