How to show two row values in single row as two coluns

DAX DAX Calculations
1

I have below requirement

I have table A dimension which classify the table as New ,OLD,Expire
ClassificatioID Classification
1 NEw
2 OLd
I have one fact table which has al transation records for each classification
Fact table
ClassificationId classificationname Monthid value
1 New 1 100
2 OLD 2 200

now my output as below

classificaion slicer

and
2month slicers one for Selectmonth and one more for previosmonth(this can be user choice)
for single product lets Say Soaps

my repot is shoowing as 2 records like below
Productname selmonth prevmonth seleclassifi prevclassifi sevalue prevalue
Soap 1 2 new new 100
Soap 1 2 Old Old 200

but actual requiremnet is as below it should show in single row
Productname selmonth prevmonth seleclassifi prevclassifi sevalue prevalue
Soap 1 2 new old 100 200

how to achive kindly do needful

2

Hi @amruthdna2018,

Can you provide a sample of your data in Excel or PBIX, think I’m missing something in the data you provided above but we should be able to sort this in Power Query.

1 Like
3

Thanks for posting your question @amruthdna2018. To receive a resolution in a timely manner please make sure that you provide all the necessary details on this thread.

Here is a potential list of additional information to include in this thread; demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

Including all of the above will likely enable a quick solution to your question.