transform data
2 Topics
Transform DATA
Hi All, Below is the problem statement. Need help with this. I have a a data set with One of the rows containg Date. I want to import the data which has only the latest date. New rows with latest date keep getting added everyday. Whenever the Dahsboard refreshes, I want the data which has the latest date (only one date). That date is not necessarily yesterday, it could be anything but has to be the latest date. Can someone help me build this logic? regards, SantoshSolved682Views0likes1Comment
Transposing / Transforming data with DAX
I want to transform the data from this format: ID CaseNumber Asset1 Asset2 AA BB 1 2 CC DD 3 4 To this format: ID CaseNumber Asset Value AA BB Asset1 1 AA BB Asset2 2 CC DD Asset1 3 CC DD Asset2 4 Since columns Asset1, Asset2, Asset3, etc. are calculated column in DAX I cannot use PowerQuery to unpivot the data. Let me know any solutions with DAX. Thanks!!Solved1.1KViews0likes5Comments