TRICKY - Matric or Standard Table in Power BI Where column are month Specific

[Anonymous]

Hi Experts

See attached sample Data in PBIX File.

https://www.dropbox.com/s/7zec9fire303cll/Sample__.pbix?dl=0 

What i would like is to select month Jan and Year 2021 and Show the table as is Jan 21 in a Table Visual (LIKE FOR LIKE) and like Select Feb and Year 2021 and Show the data ffrom table Feb 21 in a table visual. 

As you can see there are slight difference in the column headers in each table for the Months Jan and Feb. 

How would do you this and is it possible using the Month and Year Slicers, to reproduce the Table Jan 21 and Feb 21 (like for like).

[Anonymous · Accepted solution]

Hi @Anonymous ,

Based on your description, I did a test. You can do some steps as follows.

1. I duplicated "Jan 21" for demonstration. "Feb 21" is the same way.

2. Then append two tables.

3. Create month slicer and Year slicer.

Result:

Hope that's what you were looking for.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Yuna. Many thanks, but can you remove the PBIX file from the question the demo is fine....thanks

[Anonymous]

Hi @Anonymous ,

Thanks for your reply. I have removed it. 😊

Best Regards,

Yuna

[Anonymous]

Hi Yuna....could you kindly have a look totally stuck 

https://community.powerbi.com/t5/Desktop/Previous-Month-Reports-Error-in-DAX/m-p/1770485#M693953

[selimovd]

Hey @Anonymous ,

from my point of view it doesn't make sense to keep fact tables for every month.

Go to Power Query and combine all the fact tables to one big fact table. Take a look at that article how to do that:

https://whatthefact.bi/power-bi/dax/combine-multiple-tables-with-union-union-all-in-sql-server-append-in-power-query-or-union-in-dax/

Then you can use the slicer from the date table and slice the big table.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[Anonymous]

Hi Denis...thats what I need help with on how.to glue everything together and make it work..appreciate you looking at my question.