Forum Discussion

Mahadi's avatar
Mahadi
Frequent Visitor
4 years ago
Solved

Value count problem

Hello good people, I am a new Power BI learner and have encountered a problem while designing a data model. I have attached the file where I am working on ContosoDW. You can see the values are the sa...
Need Help
  • TheoC's avatar
    TheoC
    4 years ago

    @Mahadi okay, all you need to do is add a new column in the DimProduct table like below and then use the YEAR from the DimProduct table instead of the Date table.  Keep the Count of ProductName the same.

     

     

     

    Hope this helps!

     

    Theo ğŸ™‚

Mahadi's avatar
Mahadi
Frequent Visitor
4 years ago

 

Hi TheoC , it didn't work. I cannot figure out what's the problem actually. 

TheoC's avatar
TheoC
Community Champion
4 years ago

Hi Mahadi,

 

Certainly take a look at what HotChilli has provided. It makes a lot of sense. I'd recommend following their approach to correcting the data model.

 

If you need more information on what HotChilli has provided, make sure to comment and ask them. The Super Users and Community members are pretty amazing people!

 

All the best and look forward to you getting a solution for your current issue.

 

HotChilli Thanks heaps for helping out!

 

Cheers guys!

Theo