Forum Discussion
Financial calculations using DAX based on GL Data
this can be achived in following manner-
If all above are separate measures then use the feild parameter to create new table for the names of those measures and put that new column in the metrics and drag and drop the calculated measures in Values field.
to create new table using feild parameters:
New Parameter>Feilds>
add your 4 measures in Add and reorder feilds and click ok.
Thanks for the reply vaibhavkale570.
I have tried following your steps. But this creates a field parameters and that eventually creates a column. I want the fields in field parameters as a rows. Since this is financial reporting, I need vertical calculations.
IF you have only four calculations as shown above, you can create measures and then use those measures in feilds parameter. this way you will be able to use feilds as rows in your feilds parameter .
you can use the SWITCH and selectedvalue DAX function for that .
it's bit difficult for me to write the dax without the samplec data.