Usage by daily, monthly and yearly

[TaufikMaggangka]

Hi all, 

Please if someone can help. Basically, I want to create chart visualization of class usage from attendance of student by daily, monthly and yearly.

I have create a sampel data on the excel below link. Let me know if you need for future data.
https://1drv.ms/x/s!AkqCbqtIUWCygRBSKRPloMujejwA?e=FE92Al

Your support really appreciate. Just stuck on this things for few days and I can got correct number.

[amitchandak]

@TaufikMaggangka , You can join the date with a date table having - Date, Month, year, etc and can use count(Table[ID])  for attendance.

You can use hierarchy to drill down or create different visuals 

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[TaufikMaggangka]

Hi @amitchandak ,
To be honest I didnt really understand what you mean. Would you like to give me an exampel pbix ?

Your future help will be really appreaciate

[amitchandak]

@TaufikMaggangka , Check if the file attached after signature can help 

[TaufikMaggangka]

Hi @amitchandak ,

Tahnk you so much for your help, But i have an issue when i try to create gaue with filter by year and month. The result always 100%.

But it working properly by day and monthly.

Your future help will be really appreciated.