Hi ALL,
I am new to Power BI. I am working with database which imports data from different tables. I am generating a visual table that summarizes the columns that I want. But, I would like to create a column based on a measure I have created.
For example, I have TableA which has numerical data that was taken at certain time stamps. TableB has the time stamp related to the numerical data from TableA. TableC has data taken at different levels (i.e. columns for levelA, levelB etc).
My goal is to display Numerical data from TableA at different levels but where the timestamp is the latest. I have generated a measure that displays the latest Time based on given label. For example, LastTimeLevelA, LastTimeLevelB and so on and it is working. I want to know how can I create new measures/columns now that shows Numerical data from TableA that occurs at different levels based on the latest time stamp. In short, I am trying to create columns for each Levels to show Numerical data for latest Time stamp.
Thanks,
Regards.
Jatin.
