Forum Discussion

V-lianl-msft's avatar
V-lianl-msft
Community Support
5 years ago

Hi Anonymous ,

 

Based on your description. Do you want to judge whether the start and end date is in the current week?

Measure = 
var S_This_Week = WEEKNUM(MAX([Planned Start Date]),1) = WEEKNUM(TODAY(),1)
var E_This_Week = WEEKNUM(MAX([Planned End Date]),1) = WEEKNUM(TODAY(),1)
return S_This_Week&&E_This_Week

 

 

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

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for the PBIx file. Unforturnately my PBI version is not updated but thats okay. I can check the formula you shared.

 

Yes, so I have a filter in ServiceNow as share above so when I actually extract today as This week it shows me changes that are part of current week which is Monday to Sunday so if I run it today it will be from 3rd May 2021 to 9th May 2021. So thats how I want to pull it and the other charts would interact accordingly.

 

Also 2 other things :-

 

1. I have pulled up the complete change request table from Snow and the data is present on PowerBi. there is a field called "Prority" when I first pulled up the whole table and pulled the field into the visualization pane it showed me High, Medium, Low etc but after sometime it shows me blank. I tried to refresh the data but nothing works. When I checked the field I can see all the details in it and nothing is blank in the column. its only when I pull it in the visualization nothing comes up. Can you help?

 

2. Im trying to build a dashboard that would give me month on month and week over week changes etc and percentage of change request with the total etc something similar what we see in this video. Can you help with some basic things I should be adding from this that can be done. Like Percentage of successful changes etc

 

https://www.youtube.com/watch?v=q96bCfDPqr0

 

Thanks in advance for your help!