create a new measure based on slider selection

[Zu]

a slider next to each table allow s to select the month in each tableHi,

This is result table in ExcelI need help to create a third table showing the difference between each cell in this two tables. The content of the tables is controled by the Month sliders. In the case of this example, the new table will calculate (Jan-Feb) and data will be showed by level, same for all the other columns. So for level one it will be (376-373)=3. See second image for the third table in Excel.

The columns Staff Count, Ave Tenure; etc. are measures that I created.

I tried to read the values selected in the sliders and use that as parameters for a new measure,based on this article Parameter Table. But is not working, it returns 0 for all levels. Can anyone help with the measure I created or any other solution that will give me a table with the difference cell by cell.

Thanks!

[ankitpatira]

@Zu Since you have two tables with Level columns and same values for each,

in power bi desktop go to query editor -> under Home tab -> Combine ribbon -> Merge queries. This will give you values in same table for matching Levels. Then just create a measure to subtract one from another. Can you take this approach ?

[Zu]

@ankitpatira: Thanks for your help! this solution won't work for me because the tables that you see in my first post are created in the Report view, they actually don't exist in my Data model. The rows in these tables such as 'Staff Count' is a mesure that I created by counting the raws in my data table. but I don't have a column name 'Staff Count' in my data table. The other limitation is that I have a single data table, see image below. The two tables in the Report view, are based on this single data table (table1) they just display data for different month, depending on the slicer selection. (I have a column Month in my table 1). Is there a way to save the report tables as data tables?

Thanks!

[v-sihou-msft]

@Zu

The table you created in Report View is only for rendering. It's not supported to save visuals as dataset. You have to do modeling in Data View or "Edit Query".

Regards,

[Zu]

@v-sihou-msft

I suspected that Simon, thanks for confirming. Do you have any idea of documentation on how to save data model from a mesure in Power BI?