How to make weekly and monthly slicer in power bi using azure devops data

[hariram2]

Hi Team,

I have a task like how much of percentage of hours spent in individual project in azure devops using power bi report.That report manager want to weekly or monthly using slicer.

Please help here

[Arul]

@hariram2 ,

You need to have date in your table and then you have to 

Create calculated columns in your table using DAX, 

month-> month function, week->weeknum,

Please refer this thread,

https://community.powerbi.com/t5/Desktop/Need-to-create-a-month-and-week-slicer-but-have-multiple-da... 

Thanks,

Arul