User Profile
Prathamesh_29
Frequent Visitor
Joined 1 year ago
User Widgets
Contributions
Re: Calculate weekend sales into weekdays(closest working day in the current month)
First Assign No to for week DayOfWeek = WEEKDAY('Sales'[Date], 2) then Shift the value for sat ton fri and sunday to mon 2) ClosestWorkingDay = SWITCH( TRUE(), WEEKDAY('Sales'[Date], 2) = 6, 'Sales'[Date] - 1, WEEKDAY('Sales'[Date], 2) = 7, 'Sales'[Date] + 1, 'Sales'[Date] -- Keep the date for weekdays ) 3)AdjustedSales = SUMX( FILTER( ALL('Sales'), 'Sales'[ClosestWorkingDay] = EARLIER('Sales'[Date]) ), 'Sales'[Sales] )1.3KViews0likes0CommentsRe: How Connect User from One server to another server for viewing Report
Thanks ChrisMuthmann For Clarification Actually the company is not taking Risk of joining the server by thier same domain they told me to carry out the function in other 2 pc with 2 server and where this situation is there of pbirs and active directory just help out if i got stuck some where1.5KViews0likes0CommentsHow Connect User from One server to another server for viewing Report
As In our work place we have 2 server as in one server has Bi reporting service and the other server has active directory where the groups and users are So intially want to connect the other server to first server by the same domain name as it replicate the active directory in first domain so other server people where they are added in active directory can see the report using there credentials is it possible Thanks in AdvanceSolvedRe: How Connect User from One server to another server for viewing Report
Hey Jianpeng Li Thanks For ur Reply But I dont have the reporting Service in second server its in first server the database is too in first server only the viewer are in second server where they added by active directory as i saw solutions on this its says join 2 server by same domain so they can see by inputing there credentials https://www.youtube.com/watch?v=8aR_0Fp55mg&list=LL&index=9 - Joing by same domain https://www.youtube.com/watch?v=vCH8Fa3OpQ0&list=LL&index=2 -- and do i need to configure kerberos1.6KViews0likes0Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.