Forum Discussion

Shrey03's avatar
Shrey03
Regular Visitor
2 years ago

Summarized table based on dynamic selections

Hi All,   Below is my base table -   Date Column 2 Column 3 Column 4 Column 5 2023-12 C MF12 0 0 2023-11 C MF12 0 0 2023-12 E MF12 0 0 2023-11 E MF12 0 4835 ...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Shrey03 ,
I create a table as you mentioned.

Then I create two calculated columns.

Cal Col1 =
VAR _B =
    ABS ( 'Table'[Column 5] - 'Table'[Column 4] ) * 100 / 'Table'[Column 4]
RETURN
    IF ( 'Table'[Column 4] = 0, 0, _B )
Cal Col2 =
'Table'[Cal Col1] * 'Table'[Column 4]

In the latest version, I think you can manually open the Total value you need.

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Shrey03's avatar
Shrey03
Regular Visitor
2 years ago

Hi Anonymous,

 

Thank you for the reply. Can you please help using the base table as below 

to arrive at the highlighted numbers by creating measures as these numbers would be required for further caculations hence having those in Measures would help

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Shrey03 ,

    Are there some columns provided in image 2 or none at all? If none of them are provided, I don't think it can be realized. This is because when New Table is created, there needs to be a link to create the new table.

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.