Need help with creating table (urgent)

Question

&nbsp;Metric&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Current Year&nbsp; &nbsp; &nbsp;Previous&nbsp; &nbsp; Year DifferenceTotal Sales&nbsp; &nbsp; &nbsp; &nbsp;$X (2022)&nbsp; &nbsp; &nbsp; &nbsp; $Y (2021)&nbsp; &nbsp; +% ChangeAverage Sales&nbsp; $A (2022)&nbsp; &nbsp; &nbsp; &nbsp;$B (2021)&nbsp; &nbsp; +% ChangeMin Sales&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$C (2022)&nbsp; &nbsp; &nbsp; &nbsp;$D (2021)&nbsp; &nbsp;+% ChangeMax Sales&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$E (2022)&nbsp; &nbsp; &nbsp; &nbsp;$F (2021)&nbsp; &nbsp; +% Changemy power bi file:https://drive.google.com/file/d/1qclSXAgJT96yRblaaG-Y4NGrvS4oLJqY/view?usp=drive_link&nbsp;Any help will be great, i been trying various ways but i cant figure how to do this

anthonygenovese · Answer

You will need to provide more detail in order to get help. Are you trying to create a visual? A calculated table? What have you tried so far? What isn't working about it? What base data table &amp; columns are you trying to reference?

anonymous · Answer

I am trying to create a table or matrix visual, all i have is total sales and date column.

I tried creating measures for total,average,min and max sales for current year(2022) and previous(2021) but i cant get it in that format

anonymous · Answer

Can anyone please help me, i have to submit this by tmr&nbsp;😥&nbsp;

Forum Discussion

Need help with creating table (urgent)

3 Replies

Related content

Create new table

Lakehouse Table Generate Create Table

Create rows from 2 tables

Creating Date Tables

Urgent question about Policy update